[Logician]

Today at 08:02 PM JohnXWA said this in Post #113
Crap

I installed VB 2.3.0 and this broke WebTemplates which I knew was gonna happen. So as I was on the old version, I went to install this one.

I can't run the SQL queries in the file, I keep getter errors. phpMyAdmin just reports SQL Error. However a small script called MySql Table Manager reports:

You have an error in your SQL syntax near '; INSERT INTO `wt2_themes` (`themeid`, `themename`, `themesortorder`, `themeban' at line 1 Number of Rows affected: -1

Any ideas?

I can not say whether or not you can run the queries with other tools but I know that phpmyadmin runs them successfuly. As a matter of fact that query list is compiled with phpmyadmin in the first place so it will run them successfully too.

So my suggestion will be:
1- If your phpmyadmin is an old version, upgrade to the last version first.
2- Make sure you have permissions to run INSERT/UPDATE queries in MYSQL via phpmyadmin (check with your host) and confirm with by running a test INSERT/UPDATE query.
3- Then run the queries in phpmyadmin.

There are 2 ways of running it both of which are mentioned in the instructions. Although I confirmed that both works, try the other one if one fails for you.

If this still fails, I would suspect your PHP.ini or MYSQL configuration is not allowing you to send large number of texts to the server and if this is the case, you might try to run the queries in the query list in smaller groups. Or send the list to your host and they can run for you.