Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Recommended Posts

Posted

Neither have I.

 

Why do you need an sql folder?

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 ======>>>>>.

Posted
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.

Posted
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.

Posted
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

Posted

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!

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 ======>>>>>.

Posted
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?

Posted
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.

Posted (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 by onecoup

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.

Guest
Unfortunately, your content contains terms that we do not allow. Please edit your content to remove the highlighted words below.
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...