ERROR 1064 (42000) at line 1 When updated RoundCube 0.4.2

nmb

Verified User
Joined
Sep 13, 2008
Messages
223
I just ran an update and found error when updated RoundCube as below:

Code:
Updating RoundCube webmail.
--2010-11-04 18:17:47--  [url]http://files.directadmin.com/services/all/roundcube/roundcubemail-0.4.2.tar.gz[/url]
Resolving files.directadmin.com... 72.35.85.222
Connecting to files.directadmin.com|72.35.85.222|:80... connected.
HTTP request sent, awaiting response... 200 OK
Length: 2172565 (2.1M) [application/x-gzip]
Saving to: `/usr/local/directadmin/custombuild/roundcubemail-0.4.2.tar.gz'

100%[===========================================================================================>] 2,172,565    221K/s   in 15s     

2010-11-04 18:18:03 (140 KB/s) - `/usr/local/directadmin/custombuild/roundcubemail-0.4.2.tar.gz' saved [2172565/2172565]

tail: cannot open `120' for reading: No such file or directory
tail: cannot open `122' for reading: No such file or directory
Updating mysql database ...
ERROR 1064 (42000) at line 1 in file: '/var/www/html/roundcubemail-0.4.2/SQL/mysql.update.proper.sql': 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 '==> /var/www/html/roundcubemail-0.4.2/SQL/mysql.update.sql <==
/*!40014 SET FORE' at line 1
Editing roundcube configuration...
Roundcube 0.4.2 has been installed successfully.
This instance of Roundcube is up-to-date.
Have fun!

Do I need something to fix it or it's normal when updated RoundCube?


Thank you,
________
STARCRAFT 2 REPLAYS
 
Last edited:
cd /usr/local/directadmin/custombuild
./build update
./build clean
./build roundcube d
 
I had the same problem when upgrading from 0.4 to 0.4.2. I reported it to DirectAdmin, but you should also report it, so that they know it is a problem for several people.

However, Roundcube seems to work fine after the upgrade.

Also, please disregard the message from "scsi", because the problem exist even if you first do a ./build update
 
We also have problems when updating to 0.4.2

output:

./build roundcube
cp: `/var/www/html/roundcube/logs' and `/var/www/html/roundcubemail-0.4.2/logs' are the same file
cp: `/var/www/html/roundcube/temp' and `/var/www/html/roundcubemail-0.4.2/temp' are the same file
Editing roundcube configuration...
Roundcube 0.4.2 has been installed successfully.

Fatal error: Call to undefined function: spl_autoload_register() in /var/www/html/roundcubemail-0.4.2/program/include/iniset.php on line 110

seems to be an error between php4 and php 5
according to this topic:

http://www.directadmin.com/forum/showthread.php?t=37129

but I dont understand the meaning because we use php4 and 5 both..
any idea's

regards Marco
 
it's case of update.
try remove roundcube database/
then remove exiting folder
Code:
rm -rf /var/www/html/roundcube*
then update
 
Back
Top