Author Topic: There has been an error processing your request  (Read 4937 times)

Offline hip

  • Newbie
  • *
  • Posts: 6
  • Karma: +0/-0
    • View Profile
There has been an error processing your request
« on: April 04, 2013, 10:48:20 AM »
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.

Offline abolabo

  • core-developer
  • Administrator
  • Hero Member
  • *****
  • Posts: 1806
  • Karma: +256/-11
  • web for all, all for web!
    • View Profile
    • AbanteCart
Re: There has been an error processing your request
« Reply #1 on: April 04, 2013, 10:56:52 AM »
run this sql
Code: [Select]
insert into stores values (0,'default','default',1);in phpmyadmin.
Also check after run that data was pasted correctly.
“No one is useless in this world who lightens the burdens of another.”
― Charles Dickens

Offline hip

  • Newbie
  • *
  • Posts: 6
  • Karma: +0/-0
    • View Profile
Re: There has been an error processing your request
« Reply #2 on: April 04, 2013, 11:46:44 AM »
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

Offline abolabo

  • core-developer
  • Administrator
  • Hero Member
  • *****
  • Posts: 1806
  • Karma: +256/-11
  • web for all, all for web!
    • View Profile
    • AbanteCart
Re: There has been an error processing your request
« Reply #3 on: April 04, 2013, 11:58:58 AM »
hm... table stores has always existed. maybe you deleted it.
“No one is useless in this world who lightens the burdens of another.”
― Charles Dickens

Offline hip

  • Newbie
  • *
  • Posts: 6
  • Karma: +0/-0
    • View Profile
Re: There has been an error processing your request
« Reply #4 on: April 04, 2013, 12:16:56 PM »
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?

Offline abantecart

  • Administrator
  • Hero Member
  • *****
  • Posts: 4199
  • Karma: +259/-9
    • View Profile
    • Ideal Open Source Ecommerce Solution
Re: There has been an error processing your request
« Reply #5 on: April 04, 2013, 03:59:28 PM »
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]
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]
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);
We need your help to build better free open source eCommerce platform for everyone.
See how you can help

Offline hip

  • Newbie
  • *
  • Posts: 6
  • Karma: +0/-0
    • View Profile
Re: There has been an error processing your request
« Reply #6 on: April 04, 2013, 05:51:39 PM »
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>

Offline abolabo

  • core-developer
  • Administrator
  • Hero Member
  • *****
  • Posts: 1806
  • Karma: +256/-11
  • web for all, all for web!
    • View Profile
    • AbanteCart
Re: There has been an error processing your request
« Reply #7 on: April 05, 2013, 05:41:35 AM »

it looks like partial upgrade of abantecart.
What version you have? look inside core/version.php
“No one is useless in this world who lightens the burdens of another.”
― Charles Dickens

Offline abantecart

  • Administrator
  • Hero Member
  • *****
  • Posts: 4199
  • Karma: +259/-9
    • View Profile
    • Ideal Open Source Ecommerce Solution
Re: There has been an error processing your request
« Reply #8 on: April 05, 2013, 07:42:54 AM »
To save time I would reinstall to new database and later copy data that you need.
We need your help to build better free open source eCommerce platform for everyone.
See how you can help

Offline hip

  • Newbie
  • *
  • Posts: 6
  • Karma: +0/-0
    • View Profile
Re: There has been an error processing your request
« Reply #9 on: April 05, 2013, 09:39:20 AM »
This is the version that is running:

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

Offline abantecart

  • Administrator
  • Hero Member
  • *****
  • Posts: 4199
  • Karma: +259/-9
    • View Profile
    • Ideal Open Source Ecommerce Solution
Re: There has been an error processing your request
« Reply #10 on: April 05, 2013, 10:43:06 AM »
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.
We need your help to build better free open source eCommerce platform for everyone.
See how you can help

Offline hip

  • Newbie
  • *
  • Posts: 6
  • Karma: +0/-0
    • View Profile
Re: There has been an error processing your request
« Reply #11 on: April 05, 2013, 11:11:25 AM »
To migrate the data do I just need to import the database or are there certain files I need?

 

Powered by SMFPacks Social Login Mod