Jump to content
  • Checkout
  • Login
  • Get in touch


The e-commerce.

Create custom tables in database on install?


Recommended Posts



I've tried searching for an answer to my question, but my search terms are simply generating too many false leads.


I am doing some customization of osCommerce and I want to create some custom tables in the osC database.


I was pretty sure that adding my tables through catalog/install/oscommerce.sql was the way to go, but I'm not having any luck getting the new tables instered into the database on an install.


Any thoughts on what I might be doing wrong?



Link to comment
Share on other sites

i've done this same thing before - and i did it by adding the tables to the oscommerce.sql file. it worked fine. if you can describe specifically what is or is not working i might be able to help.


one thing to note, however: when processing the oscommerce.sql file, the installer breaks up the file into separate commands separated by semi colons. i had a semi colon in a comment within the file and that caused a problem.

Link to comment
Share on other sites

Thanks for the reply.


Out of frustration I've deleted all instances of oscommerce.sql I can find and the DB is still getting created with the default tables, so I'm guessing h-sphere is doing something different when it installs osC.


I guess I'll have to start poking around somewhere else (like my eye ... with a sharp stick).

Link to comment
Share on other sites

Well, it turns out that the oscommerce.sql file that is controlling the database installation was residing on a completely different server from where the osC tarball is residing.


Just goes to show that IT is not my specialty :)

Link to comment
Share on other sites


This topic is now archived and is closed to further replies.

  • Create New...