Submitted by beat on Mon, 11/09/2009 - 12:06
Nothing urgent, just noted on the way: Zikula script installer has bug with strange characters at begin
Installation result:
Found http://code.zikula.org:80/core/downloads/169 in cache ..
Configuring Apache PHP settings .. .. already done. Now installing Zikula version 1.2.0 .. Failed to run database setup script : ERROR 1064 (42000) at line 1: 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 '/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */' at line 1 . More information on using this script can be found at http://zikula.org/.
.. installation was only partially complete. Re-loading Webmin .. .. done
Status:
Closed (fixed)
Comments
Submitted by JamieCameron on Mon, 11/09/2009 - 12:20 Comment #1
That's really odd .. I don't see this on my system.
Could you attach the file matching docs/Zikula-*-MySQL.sql under the install directory to this bug report, or email it to me at jcameron@virtualmin.com
Submitted by Lior on Mon, 01/11/2010 - 22:36 Comment #2
I got the same issue as above.
Failed to run database setup script : ERROR 1064 (42000) at line 1: 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 '/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */' at line 1 .
Submitted by JamieCameron on Mon, 01/11/2010 - 23:27 Comment #3
Lior - could you attach that script mentioned in comment #1, or email it to me at jcameron@virtualmin.com ?
Submitted by Lior on Tue, 01/12/2010 - 09:31 Comment #4
See attached. renamed to .txt
WOOPS. wrong file. I have the eticket issue as well. Correct file will follow.
Submitted by Lior on Tue, 01/12/2010 - 09:32 Comment #5
This is the correct script file for the issue above. renamed to .txt
Submitted by JamieCameron on Tue, 01/12/2010 - 11:36 Comment #6
Lior - actually, the file I wanted is under the directory you selected to install Zikula into, named something like
docs/Zikula-1.2.0-MySQL.sql
Submitted by Lior on Tue, 01/12/2010 - 12:56 Comment #7
There is nothing like that. However looking in there I found an install folder that contains a web installer, it seems that to complete the installation, it has to be done via the web interface of eticket.
I attached that create script from the /eticket/install folder.
I have not yet run the web script, if you want the check anything else. I will wait to hear from you.
Submitted by Lior on Tue, 01/12/2010 - 12:57 Comment #8
grrrr, I keep doing that. ignore the abouve, thats for eticket. I keep mushung the issues together in my head
Submitted by Lior on Tue, 01/12/2010 - 13:00 Comment #9
this is the file as originally requested. sigh, sorry about the confusion.
Submitted by JamieCameron on Tue, 01/12/2010 - 13:56 Comment #10
That file looks OK to me...
Which MySQL version are you running?
Submitted by Lior on Tue, 01/12/2010 - 14:13 Comment #11
MySQL version 5.0.51
Submitted by JamieCameron on Tue, 01/12/2010 - 18:06 Comment #12
Ok, thanks .. for some reason, that file appears to contain bogus characters in the Zikula tar.gz file.
I will fix this in the next Virtualmin release, and ask the Zikula developers where those are coming from.
Submitted by Issues on Tue, 01/26/2010 - 19:20 Comment #13
Automatically closed -- issue fixed for 2 weeks with no activity.