Mysql_zencart.sql modification

[tony_sar]

Hello.
I have patched and bug fixed zencart 1.38 and adding some modules. i need to add some sql commands that comes with some modules to mysql_zencart.sql so they can be added to database during zc installation.
I have tried by adding those commands to the file , but installation zc installer seems to ignore them . any other way i can have those commands installs during zc installation ?

[DrByte]

Don't touch the master file.
If you have extra SQL statements you want to run as part of zc_install, put them in the /zc_install/sql/plugins/ folder, and name them as "mysql_xxxxxx.sql". All files in that folder following that naming convention will be processed in alphabetical order after the main install script runs.

[tony_sar]

excellent . thanks a lot

[tony_sar]

none of the sql file in plugins folder installs

[tony_sar]

sorry for a bump . but i tried almost anything i could possibly think of , and yet none of sql files are installing . any other suggestion ?

[kuroi]

Hi Tony

DrByte is right that changing the main file is unnecessary and to be avoided. Nevertheless, when you did so that should have worked. That it didn't, and neither did the files for extra sql, suggests that there's something wrong with the SQL itself. But you haven't told us anything about what you're trying to do, the SQL that you're using, or how you conclude that it's not working.

[tony_sar]

i have fresh zc 1.38, I have added all bug fixes and patches .. also done all override . i have added few modules , some of those modules comes with sql file . what i am trying to do is to create a moded zencart so when i install zencart , i wont have to install all those modules and override and sql files over and over again . everything so far works fine except sql files in plugins folder are not installing . those sql files do add extra configuration values under configuration . once im done installing , i don't see those configuration in admin nor they are in Database . .

[DrByte]

I don't know why it's not working for you. I use it every day without problems, so as kuroi said, perhaps your problem is with what you've put in the files, or with the names of the files themselves or the folder you've placed them in.

[tony_sar]

Thanks DrByte and Kuroi for info . I did a test again with untouched zencart .
for test i used install.sql file that comes with zen light box module . i renamed it to mysql_lightbox.sql, then moved the file to zc_install/ sql / plugins folder .

i installed zencart . everything is fine in zen cart side but yet nothing from mysql_lightbox.sql has been added to the database.
any other suggestions??