Database Table Prefix & Mods

[philip937]

Can anyone tell me if I install a database patch using the admin install patches function if this automatically sets the database table prefix?

I have a client that has zen_ prefix and not sure if I have to amend the modules sql patch file and add the prefix to all the tables referenced in the file?

Thanks in advance.

Phil

[stevesh]

Not in my experience, no. You have to edit the SQL in the patch to add the prefix.

[philip937]

Not in my experience, no. You have to edit the SQL in the patch to add the prefix.

Cheers mate :o)

I'll add one of the sections with the added prefix and see what happens, I can alway delet if I end up with zen_zen_ I guess.

Thanks for your reply

[DrByte]

Yes, the Zen Cart admin Install SQL Patch tool does automatically insert the DB_PREFIX value correctly in simple SQL statements. Complex joins need to be rewritten to put join syntax on new lines so the parser can insert the prefix properly on joined table names. There are many examples of these in the upgrade .sql files in the zc_install/sql/ folder if you need such to follow.

[philip937]

Yes, the Zen Cart admin Install SQL Patch tool does automatically insert the DB_PREFIX value correctly in simple SQL statements. Complex joins need to be rewritten to put join syntax on new lines so the parser can insert the prefix properly on joined table names. There are many examples of these in the upgrade .sql files in the zc_install/sql/ folder if you need such to follow.

Cheers Doc, yeah worked fine. was scary though!

Thanks for letting me know