Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Create custom tables in database on install?


agromatic

Recommended Posts

Posted

Hello,

 

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?

 

Thanks!

Posted

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.

Posted

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

Posted

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 :)

Archived

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

×
×
  • Create New...