Blesta Install Error

[atmarcos]

hi,

I'm going through the following problem when performing a new installation:

SQLSTATE[42000]: Syntax error or access violation: 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 'ALTER TABLE `client_fields` ADD `read_only` TINYINT( 1 ) UNSIGNED NOT NULL DEFAU' at line 2 on line 147 in /chroot/home/XXXX/XXXXX.XXX/html/XXXX/lib/model.php 

Does anyone here have been through this kind of problem?

[atmarcos]

Solve reinstalling mysqld.

 

42 minutes ago, Licensecart said:

May I ask why you are using a so outdated version of PHP? you should be on at least 5.5

[Paul]

What version of MySQL are you running?

This came up before here - 

The error code normally indicates an SQL syntax error according to MySQL, but I'm not sure that's entirely accurate. This other user installed on a different machine and moved the database. If you install on a different machine and move it, just follow the Moving Blesta guide.

[atmarcos]

hi Paul,

It is a new installation of Blesta.
New database.

PHP 5.3.3
mysql  Ver 14.14 Distrib 5.1.73, for redhat-linux-gnu (x86_64) using readline 5.1

[Michael]

6 minutes ago, atmarcos said:

hi Paul,

It is a new installation of Blesta.
New database.

PHP 5.3.3
mysql  Ver 14.14 Distrib 5.1.73, for redhat-linux-gnu (x86_64) using readline 5.1

May I ask why you are using a so outdated version of PHP? you should be on at least 5.5

[Michael]

4 minutes ago, atmarcos said:

Solve reinstalling mysqld.

 

Ah bloody MySQL never liked that lol that's why I went MariaDB, but why PHP5.3   lol