onecoup Posted April 29, 2008 Posted April 29, 2008 I have no idea of the location of /sql folder. please help. thanks Quote
♥geoffreywalton Posted April 29, 2008 Posted April 29, 2008 Neither have I. Why do you need an sql folder? Quote Need help installing add ons/contributions, cleaning a hacked site or a bespoke development, check my profile Virus Threat Scanner My Contributions Basic install answers. Click here for Contributions / Add Ons. UK your site. Site Move. Basic design info. For links mentioned in old answers that are no longer here follow this link Useful Threads. If this post was useful, click the Like This button over there ======>>>>>.
onecoup Posted April 30, 2008 Author Posted April 30, 2008 Neither have I. Why do you need an sql folder? it's for the installation of infobox, which needs information.sql and information_table.sql. it's another creation of a new sql database on my server, isn't it? sorry for any impoliteness from the"I", I am not a native speaker. Quote
Guest Posted April 30, 2008 Posted April 30, 2008 it's for the installation of infobox, which needs information.sql and information_table.sql. it's another creation of a new sql database on my server, isn't it? sorry for any impoliteness from the"I", I am not a native speaker. You need to run those files in your database. Quote
onecoup Posted April 30, 2008 Author Posted April 30, 2008 You need to run those files in your database. Is it ok to add the same user of the existing database to information.sql? tks Quote
♥geoffreywalton Posted April 30, 2008 Posted April 30, 2008 If those 2 files contain sql commands to update/change your database, then this is how you do it. (If you don't, then please ignore this post) 1) Go to your ISPs admin area for your site. 2) Click on the icon for Mysql, then find the link for phpmyadmin, it might be hidden away at the bottom but not on all admin sites. If you can’t find this, please consult your ISP's help desk. 3) In some cases, you may have to choose which database your OSC tables are located on. If this is the case, please choose using the dropdown box. 4) Click on "SQL" on the navigation bar. 5) Enter/paste your SQL in the textbox provided or, if you have a file containing the sql commands, click on Import and follow the on screen prompts. 6) For both methods click "Go".. 7) If all goes well, your SQL query will run successfully For another explanation see:- http://www.oscommerce.com/forums/index.php?sho...dmin+mysql+code Or for a contribution to allow you to run SQL Script from Admin http://www.oscommerce.com/community/contributions,4567 Cheers! Quote Need help installing add ons/contributions, cleaning a hacked site or a bespoke development, check my profile Virus Threat Scanner My Contributions Basic install answers. Click here for Contributions / Add Ons. UK your site. Site Move. Basic design info. For links mentioned in old answers that are no longer here follow this link Useful Threads. If this post was useful, click the Like This button over there ======>>>>>.
onecoup Posted May 1, 2008 Author Posted May 1, 2008 If those 2 files contain sql commands to update/change your database, then this is how you do it. (If you don't, then please ignore this post) 1) Go to your ISPs admin area for your site. 2) Click on the icon for Mysql, then find the link for phpmyadmin, it might be hidden away at the bottom but not on all admin sites. If you can’t find this, please consult your ISP's help desk. 3) In some cases, you may have to choose which database your OSC tables are located on. If this is the case, please choose using the dropdown box. 4) Click on "SQL" on the navigation bar. 5) Enter/paste your SQL in the textbox provided or, if you have a file containing the sql commands, click on Import and follow the on screen prompts. 6) For both methods click "Go".. 7) If all goes well, your SQL query will run successfully For another explanation see:- http://www.oscommerce.com/forums/index.php?sho...dmin+mysql+code Or for a contribution to allow you to run SQL Script from Admin http://www.oscommerce.com/community/contributions,4567 Cheers! Thanks, I entered phpMyAdmin, found the database of my store, to install infobox, the readme file instructs me to "run the 'information.sql' file located in the /sql folder". which means to creat a file under my store database? Quote
Guest Posted May 1, 2008 Posted May 1, 2008 Thanks, I entered phpMyAdmin, found the database of my store, to install infobox, the readme file instructs me to "run the 'information.sql' file located in the /sql folder". which means to creat a file under my store database? No, you are to add or modify tables within the db by running the sql file. Where did geoffreywalton say to create a file under the database. Quote
onecoup Posted May 2, 2008 Author Posted May 2, 2008 (edited) No, you are to add or modify tables within the db by running the sql file. Where did geoffreywalton say to create a file under the database. There is a new situation: 1. during the process of installing ipuv2045, there is a new infomation.php to upload to replace the old one, the uploading has been taken for times, but the sizes of the two information.php are still 4335 butes and 4443 bytes, which means the uploading failed, but the FlashFXP did not warn. 2. also after everything is done as required, the left column disappeared in the home page, still exsits in the other sub-pages. 3. when try to log in administration tool, I got the following codes: Warning: main(fckeditor/fckeditor.php) [function.main]: failed to open stream: No such file or directory in /home/frida4/public_html/catalog/admin/includes/functions/html_output.php on line 13 Warning: main(fckeditor/fckeditor.php) [function.main]: failed to open stream: No such file or directory in /home/frida4/public_html/catalog/admin/includes/functions/html_output.php on line 13 Fatal error: main() [function.require]: Failed opening required 'fckeditor/fckeditor.php' (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/frida4/public_html/catalog/admin/includes/functions/html_output.php on line 13 please help. Edited May 2, 2008 by onecoup Quote
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.