Hi Edwin

I have come up against a new error when creating a new duplicate site;

Create table error [1064] on query [CREATE TABLE IF NOT EXISTS trm-kremco_banner LIKE `trmltdco_temphouse`.`jos_banner`]. DB Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-kremco_banner LIKE `trmltdco_temphouse`.`jos_banner`' at line 1 SQL=CREATE TABLE IF NOT EXISTS trm-kremco_banner LIKE `trmltdco_temphouse`.`jos_banner`

+ many more like this!

It work fine before I updated to multisites_V1.2.26, could this have changed something?? Still having problems installing V1.2.35 also - 'Install lag' thread.

Rgds

Jamie

Check the SQL statement in a PHPMyAdmin - this will help you identify the origin of the problem.
I suspect that the table that you want to copy does not exists.

Another hypothesis is that you put a "-" (minus) rather than an "_" underscore in the table prefix

trm-kremco_

Hi Edwin

Thanks, it seems to have been the "-" that was the problem, all is fine now!

Rgds

Jamie