America-Warehouse.com Posted May 2, 2008 Posted May 2, 2008 Hello Friends.. I've Tried to use UPSXML stuff and decide to remove them. can't get in Catalog Section in Admin try restore my back up to get my catalogs back but worse of all 1146 - Table 'ame0811706033903.reviews' doesn't exist select count(*) as count from reviews [TEP STOP] back to /catalog 1146 - Table 'ame0811706033903.whos_online' doesn't exist delete from whos_online where time_last_click < '1209730186' [TEP STOP] What did I do wrong? Thanks https://America-Warehouse.com {-- RJ --}
prafulkr Posted May 2, 2008 Posted May 2, 2008 Hello Friends.. I've Tried to use UPSXML stuff and decide to remove them. can't get in Catalog Section in Admin try restore my back up to get my catalogs back but worse of all 1146 - Table 'ame0811706033903.reviews' doesn't exist select count(*) as count from reviews [TEP STOP] back to /catalog 1146 - Table 'ame0811706033903.whos_online' doesn't exist delete from whos_online where time_last_click < '1209730186' [TEP STOP] What did I do wrong? Thanks https://America-Warehouse.com I think your table does not restore sucessfuly. try it again, this maybe solve your problem. When I was born, I was cryed and everyone around me was smiling. Live our life so at the end, I am the one who is smiling and everyone around me is crying.
Jack_mcs Posted May 2, 2008 Posted May 2, 2008 It appears that you deleted some tables from the database. If you can restore the database, then that should fix it. Jack Support Links: For Hire: Contact me for anything you need help with for your shop: upgrading, hosting, repairs, code written, etc. All of My Addons Get the latest versions of my addons Recommended SEO Addons
America-Warehouse.com Posted May 2, 2008 Author Posted May 2, 2008 Hello friends again I've tried restore the database again but it showing 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' {-- RJ --}
America-Warehouse.com Posted May 2, 2008 Author Posted May 2, 2008 Hello Friends.. I try to get in catalog and it show this Fatal error: Call to undefined function: tep_hide_session_id() in /home/content/a/m/e/americawarehou/html/catalog/admin/categories.php on line 784 Thanks again {-- RJ --}
prafulkr Posted May 2, 2008 Posted May 2, 2008 Hello friends again I've tried restore the database again but it showing 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' Please make empty your database and then restore the table. are you able to post errorlog file (last fews lines). It will help us to help you! When I was born, I was cryed and everyone around me was smiling. Live our life so at the end, I am the one who is smiling and everyone around me is crying.
America-Warehouse.com Posted May 2, 2008 Author Posted May 2, 2008 Please make empty your database and then restore the table.are you able to post errorlog file (last fews lines). It will help us to help you! Hey prafulkr.. where can i find errlog file in? i'll try empty my database.. will i lost all my products ? Thank you {-- RJ --}
prafulkr Posted May 2, 2008 Posted May 2, 2008 Hello Friends.. I try to get in catalog and it show this Fatal error: Call to undefined function: tep_hide_session_id() in /home/content/a/m/e/americawarehou/html/catalog/admin/categories.php on line 784 Thanks again please check in html_output.php file on line number295 to 304: // Hide form elements function tep_hide_session_id() { $string = ''; if (defined('SID') && tep_not_null(SID)) { $string = tep_draw_hidden_field(tep_session_name(), tep_session_id()); } return $string; } is there function tep_hide_session_id()? When I was born, I was cryed and everyone around me was smiling. Live our life so at the end, I am the one who is smiling and everyone around me is crying.
prafulkr Posted May 2, 2008 Posted May 2, 2008 Hey prafulkr.. where can i find errlog file in? i'll try empty my database.. will i lost all my products ? Thank you Yes if you empty the database then certainly you will lose your all data but if you have a backup of database then why should you bother. You may find errorlog in "home/usr/apache/logs/error.log" if ur hosting server is on linux> When I was born, I was cryed and everyone around me was smiling. Live our life so at the end, I am the one who is smiling and everyone around me is crying.
America-Warehouse.com Posted May 2, 2008 Author Posted May 2, 2008 Yes if you empty the database then certainly you will lose your all data but if you have a backup of database then why should you bother. You may find errorlog in "home/usr/apache/logs/error.log" if ur hosting server is on linux> I've Backed up last night db_ame0811706033903-20080501181231.sql 05/01/2008 18:12:31 1,707,428 bytes {-- RJ --}
prafulkr Posted May 2, 2008 Posted May 2, 2008 I've Backed up last night db_ame0811706033903-20080501181231.sql 05/01/2008 18:12:31 1,707,428 bytes its ok, then you just empty your database and try to restore againg. You have a Cpanel access? if yes then again you take a backup of your database and after that you follow this. When I was born, I was cryed and everyone around me was smiling. Live our life so at the end, I am the one who is smiling and everyone around me is crying.
America-Warehouse.com Posted May 2, 2008 Author Posted May 2, 2008 its ok, then you just empty your database and try to restore againg.You have a Cpanel access? if yes then again you take a backup of your database and after that you follow this. I've Empty the database at the hosting server. when i try restore in oscommerce it show this 1146 - Table 'ame0811706033903.configuration' doesn't exist select configuration_key as cfgKey, configuration_value as cfgValue from configuration [TEP STOP] {-- RJ --}
prafulkr Posted May 2, 2008 Posted May 2, 2008 How do i empty my database ? can I empty i t in phpMyAdmin at my hosting server ? ohh! yes u may empty ur database on hosting server. But it needs phpmyadmin user name and password. then first u take a backup of your existing database and then restore last back file to the server. If you can't do that then email me [email protected] i will do that. When I was born, I was cryed and everyone around me was smiling. Live our life so at the end, I am the one who is smiling and everyone around me is crying.
America-Warehouse.com Posted May 2, 2008 Author Posted May 2, 2008 ohh!yes u may empty ur database on hosting server. But it needs phpmyadmin user name and password. then first u take a backup of your existing database and then restore last back file to the server. If you can't do that then email me [email protected] i will do that. oh no I think I funk up? ame0811706033903 (0) No tables found in database. {-- RJ --}
prafulkr Posted May 2, 2008 Posted May 2, 2008 oh no I think I funk up? ame0811706033903 (0) No tables found in database. Ha ha ha. Thats the actual problem. Now you restore the database on hosting server then it will certainly works. No need to worry you because u said that u have taken backup last night. So restore your database and let me known. When I was born, I was cryed and everyone around me was smiling. Live our life so at the end, I am the one who is smiling and everyone around me is crying.
America-Warehouse.com Posted May 2, 2008 Author Posted May 2, 2008 Hey.. I did Copy my back up sql from /backup I import it to phpmyadmin now it showing 46 tables.. my site is back up now.. but STILL couldn't get in catalogs / products.. Fatal error: Call to undefined function: tep_hide_session_id() in /home/content/a/m/e/americawarehou/html/catalog/admin/categories.php on line 784 {-- RJ --}
prafulkr Posted May 2, 2008 Posted May 2, 2008 Hey.. I did Copy my back up sql from /backup I import it to phpmyadmin now it showing 46 tables.. my site is back up now.. but STILL couldn't get in catalogs / products.. Fatal error: Call to undefined function: tep_hide_session_id() in /home/content/a/m/e/americawarehou/html/catalog/admin/categories.php on line 784 Please post the link so i can check that.. When I was born, I was cryed and everyone around me was smiling. Live our life so at the end, I am the one who is smiling and everyone around me is crying.
America-Warehouse.com Posted May 2, 2008 Author Posted May 2, 2008 Please post the link so i can check that.. http://america-warehouse.com/catalog/admin...ted_box=catalog {-- RJ --}
prafulkr Posted May 2, 2008 Posted May 2, 2008 http://america-warehouse.com/catalog/admin...ted_box=catalog ohh no it is asking username and password. plz check catagories.php files and also html_output.php file for function tep_hide_session_id() { $string = ''; if (defined('SID') && tep_not_null(SID)) { $string = tep_draw_hidden_field(tep_session_name(), tep_session_id()); } return $string; } When I was born, I was cryed and everyone around me was smiling. Live our life so at the end, I am the one who is smiling and everyone around me is crying.
America-Warehouse.com Posted May 2, 2008 Author Posted May 2, 2008 ohh no it is asking username and password. plz check catagories.php files and also html_output.php file for function tep_hide_session_id() { $string = ''; if (defined('SID') && tep_not_null(SID)) { $string = tep_draw_hidden_field(tep_session_name(), tep_session_id()); } return $string; } Wow more work for me.. my eyes sore when trying look inside catagories.php.. i couldn't find them ? where do html_output.php sit in ? {-- RJ --}
prafulkr Posted May 2, 2008 Posted May 2, 2008 Wow more work for me.. my eyes sore when trying look inside catagories.php.. i couldn't find them ? where do html_output.php sit in ? My dear RJ that function is defined in admin/includes/functions/html_output.php and called on categories.php file on line number. 746. try to check the html_output.php and it is included in application_top.php or not or???? When I was born, I was cryed and everyone around me was smiling. Live our life so at the end, I am the one who is smiling and everyone around me is crying.
America-Warehouse.com Posted May 2, 2008 Author Posted May 2, 2008 My dear RJ that function is defined in admin/includes/functions/html_output.php and called on categories.php file on line number. 746. try to check the html_output.php and it is included in application_top.php or not or???? I'm looking in html_output.phh in /admin/includes/functions/ how do you get to line number 746 ? I copy / paste it to wordpad it show no line # {-- RJ --}
prafulkr Posted May 2, 2008 Posted May 2, 2008 I'm looking in html_output.phh in /admin/includes/functions/ how do you get to line number 746 ? I copy / paste it to wordpad it show no line # plz use any editor like crimsone editor or macromedia dreamweaver then you show line number crimsone editor if free. When I was born, I was cryed and everyone around me was smiling. Live our life so at the end, I am the one who is smiling and everyone around me is crying.
America-Warehouse.com Posted May 2, 2008 Author Posted May 2, 2008 I got it html_output.php line 746 show this ?> I also look in categories.php file on line number. 746 it show this echo tep_draw_hidden_field($key, htmlspecialchars(stripslashes($value))); {-- RJ --}
prafulkr Posted May 2, 2008 Posted May 2, 2008 I got it line 746 show this ?> plz create a dumy user for admin panel so i can check it on line and tell you how t osolve the problem. after testing you delete that user. Because i an not able to see that page. When I was born, I was cryed and everyone around me was smiling. Live our life so at the end, I am the one who is smiling and everyone around me is crying.
Recommended Posts
Archived
This topic is now archived and is closed to further replies.