tips.paddyonline.net

If you need tips & tricks, here they are...


Warning: Parameter 2 to modChrome_artnostyle() expected to be a reference, value given in /var/www/clients/client1/web13/web/templates/tips2_4/html/modules.php on line 39

Warning: Parameter 3 to modChrome_artnostyle() expected to be a reference, value given in /var/www/clients/client1/web13/web/templates/tips2_4/html/modules.php on line 39

Joomla! AddThis

Share

JInstaller::install: SQL Error

JInstaller::install: SQL Error

JInstaller::install: SQL Error. DB function failed with error number 1064

If you get this error when you try to install extensions in a Joomla 1.5.x site on a server using MySQL 5,
check this out.

I had this when trying to install eXtplorer 2.1 witch was installed since I moved from another server using older MySQL. However I had some problems with it and needed a re-install. I uninstalled the older version and then downloaded eXtplorer 2.1 v2.1RC5. When I tried to install it I got an error stating something like this....

JInstaller::install: SQL Error. DB function failed with error number 1064
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 'TYPE=MyISAM' at line 35
SQL=CREATE TABLE IF NOT EXISTS '

I unpacked the zip file and searched thru the files for
"TYPE=MyISAM"

and replaced every finding with
"ENGINE=MyISAM"

After I had done that I packed the installation again and was able to install it just fine.

Add comment

Security code
Refresh

Please consider supporting our efforts.

:

Warning: Parameter 2 to modChrome_artnostyle() expected to be a reference, value given in /var/www/clients/client1/web13/web/templates/tips2_4/html/modules.php on line 39

Warning: Parameter 3 to modChrome_artnostyle() expected to be a reference, value given in /var/www/clients/client1/web13/web/templates/tips2_4/html/modules.php on line 39
Creative Commons License
Tips&Tricks at tips.paddyonline.net is licensed under a Creative Commons Attribution-ShareAlike 3.0 Unported License.
Cookies make it easier for us to provide you with our services. With the usage of our services you permit us to use cookies.
More information Ok Decline