There has been an error processing your request

[hip]

We are getting this error on our website and the error logs are stating:


2013-04-04 9:51:31 - database error:  Error: Table 'antony_jo2kfsmtmy695177.stores' doesn't exist<br />Error No: 1146<br />SELECT se.`key`, se.`value`, st.store_id
                      FROM settings se
                      RIGHT JOIN stores st ON se.store_id=st.store_id
                       <b>/services6/webpages/util/j/o/jo2kfsmt.myutilitydomain.com/apssupplies.com/public/core/database/mysql.php</b> on line <b>86</b>

Any idea how to fix this as I went to phpmyadmin and the above database table is not there...the site was working fine before.......Thanks.

[abolabo]

run this sql

Code Select Expand

insert into stores values (0,'default','default',1);
in phpmyadmin.
Also check after run that data was pasted correctly.

[hip]

This is the error i got when running that......

Error

SQL query:

INSERT INTO stores
VALUES ( 0, 'default', 'default', 1 )

MySQL said: Documentation
#1146 - Table 'antony_jo2kfsmtmy695177.stores' doesn't exist

[abolabo]

hm... table stores has always existed. maybe you deleted it.

[hip]

I'm tech support for this website and am troubleshooting the problem.....I don't think the customer would have access to delete that table but let's just say he did ....... is there anyway to restore this table or get it back?

[abantecart]

First. Check all tables and see if tables use any prefix. Is it possible that someone changed configuration to remove prefix

Look in system/config.php

Code Select Expand

define('DB_PREFIX', 'ac_');

If this is not the case:
Check backups. Go to admin/system/backup/ directory or check admin -> system -> logs -> install/update
If there is any backup you can restore just this table

Finally, you can run below SQL:

Code Select Expand


DROP TABLE IF EXISTS `stores`;
CREATE TABLE `stores` (
  `store_id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(64) COLLATE utf8_bin NOT NULL,
  `alias` varchar(15) COLLATE utf8_bin NOT NULL,
  `status` int(1) NOT NULL,
   PRIMARY KEY (`store_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=0;

INSERT INTO `stores` VALUES (0,'default','default',1);


[hip]

Ok....that last one recreated the table...but we are still getting the "there has been an error processing your request" on the website......here is what the error logs say:


2013-04-04 17:42:09 - database error:  Error: Unknown column 'st.url' in 'where clause'<br />Error No: 1054<br />SELECT se.`key`, se.`value`, st.store_id
                      FROM settings se
                      RIGHT JOIN stores st ON se.store_id=st.store_id
                       <b>/services6/webpages/util/j/o/jo2kfsmt.myutilitydomain.com/apssupplies.com/public/core/database/mysql.php</b> on line <b>86</b>

[abolabo]

it looks like partial upgrade of abantecart.
What version you have? look inside core/version.php

[abantecart]

To save time I would reinstall to new database and later copy data that you need.

[hip]

This is the version that is running:

<?php
define('MASTER_VERSION', '0');
define('MINOR_VERSION', '9');
define('VERSION_BUILT', '1');

[abantecart]

This is very old version. I wonder if someone tried to update manually skipping versions in between.

As I suggested before, reinstall new version and migrate data.

[hip]

To migrate the data do I just need to import the database or are there certain files I need?