Database table names vs add-on modules

**willsy** · 20 Jul 2011, 05:51 PM

Hi Gurus,

I have a live site, which got installed with a database table prefix of znc_ on every table. Which is fine until I go to install an add on module where it fails because it can't find the right table names.

Question is, other than editing the install.sql of every add-on module is there another course of action I could take to fix this so I don't have this hassle every time I try to install a new module ?

Cheers,
Willsy

**gjh42** · 20 Jul 2011, 06:03 PM

Are you having problems with the SQL patch not installing to the right tables, or with the mod not finding the right tables in operation? It sounds like the former.

The solution to this is to paste the install.sql content into Tools > Install SQL Patches instead of trying to use it directly in phpMyAdmin. The Install SQL Patches page automatically detects any table prefixes and adjusts for them.

**willsy** · 20 Jul 2011, 06:42 PM

Originally Posted by gjh42

Are you having problems with the SQL patch not installing to the right tables, or with the mod not finding the right tables in operation? It sounds like the former.

The solution to this is to paste the install.sql content into Tools > Install SQL Patches instead of trying to use it directly in phpMyAdmin. The Install SQL Patches page automatically detects any table prefixes and adjusts for them.

You are absolutely right gjh42, I was using PHPAdmin. A little knowledge is a dangerous thing sometimes. Thanks so much, "Install SQL Patches" worked perfectly !