Can't Installed Blesta

[horaz]

Hi All,

 

I'm a new user in this forum, Horaz from Medan, ID. Hopefully i get knowledge and friends here.

 

I'm trying to install from the last version but still get this error

 

"

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 /home/mmserv/public_html/lib/model.php"

 

#0 /home/mmserv/public_html/lib/model.php(147): PDO->prepare('ALTER TABLE `cl...')
#1 /home/mmserv/public_html/lib/model.php(121): Model->prepare('ALTER TABLE `cl...', 5)
#2 /home/mmserv/public_html/components/upgrades/tasks/upgrade3_0_0_a4.php(81): Model->query('ALTER TABLE `cl...')
#3 /home/mmserv/public_html/components/upgrades/tasks/upgrade3_0_0_a4.php(52): Upgrade3_0_0A4->alterCustomFields()
#4 /home/mmserv/public_html/components/upgrades/upgrades.php(109): Upgrade3_0_0A4->process('alterCustomFiel...')
#5 /home/mmserv/public_html/components/upgrades/upgrades.php(58): Upgrades->processObject(Object(Upgrade3_0_0A4), NULL)
#6 /home/mmserv/public_html/app/controllers/install.php(381): Upgrades->start('3.0.0.a3', NULL)
#7 /home/mmserv/public_html/lib/dispatcher.php(111): Install->process()
#8 /home/mmserv/public_html/index.php(21): Dispatcher::dispatch('/install/proces...')
#9 {main}

 

host: cpanel/mysql 5.5.32-cll and php 5.3.26 with PDO installed

 

Thanks very much for your help

[silvatech]

Would help I knew where your getting stuck at, but I had a different issue with similar bugs. Try in cpanel if you have "select php version". If you do I would set it to native. Before setting it note what version it was set at incase you have to go back.

[Tyson]

The 3.0.0a4 upgrade script may be executing multiple queries at once. If you're familiar with php, you can update /components/upgrades/tasks/upgrade3_0_0_a4.php to run each query separately. Then clear your database and try installing again.

[horaz]

@Tyson : i'm not familiar with PHP. Can you give a detail instruction to make it works on my cpanel account. thanks.

[horaz]

i did a successfully on non-cpanel server, and copy all that files to my cpanel account - it works now.