New Install Problem

[Brian]

I am trying to install Opendocman 1.2.5.7 on a Freebsd 8.0 server using the latest PHP 5 and MYSQL ports.

I seem to have all the pieces talking to each other now but I am getting an error when I run the install:

Checking that templates_c folder is writeable... OK
installing...
Database Created
Database Selected

Could not create odm_admin tableYou 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 4


Help anyone?


Brian

[Stephen]

<!-- m --><a class="postlink" href="http://dev.mysql.com/doc/refman/5.0/en/myisam-storage-engine.html">http://dev.mysql.com/doc/refman/5.0/en/ ... ngine.html</a><!-- m -->

Some info there on the TYPE= option being deprecated, although it is supposed to be backwards compatible. Change it to ENGINE= I guess?

[Stephen]

Oh, and what version of mysql are you running?

[Brian]

Thank you very much ... that fixed the error.


Brian


Oh and I am running: My SQL Server version: 5.5.4-m3 FreeBSD port: mysql-server-5.5.4

[mad3813]

Hi, sorry I am having the same issue as the OP and was wondering where this would be changed?

Opendocman 1.2.5.7, PHP 5.3.6, Server 2003, IIS6

[Stephen]

I think that is in /install/odm.php. There are SQL queries with TYPE=**** in them. You can remove that part because the default for mysql is MyISAM.

[ruben_2424]

Hi!

I am new to PHP and MySQL. I am installing opendocman 1.2.5.7, the following appears after I click the new installation link:

Checking that templates_c folder is writeable... OK
installing...
Database Created
Database Selected

Could insert new version into db user

and if I click the odm.php from the Index of /opendocman-1.2.5.7/install

i got the following:

Could not create admin tableNo database selected

what would be the possible solution? thanks a lot!

I am using the MySQL ver 5.5.8, PHP ver. 5.3.5, Apache 2.2.17

[cmichel]

Hi,

i made it so:
open the file "database.sql" with word and replace all "TYPE=MyISAM" with " ".
Then install the SQL direct into the databasse with the import function.
Thats it ^^

best regards,
Christof

[masud62]

Dear friend,
I am trying to install this on Xampp win 32 1.2.7.4 which is on windows Xp. but could not get through with table creation. Is their any version of installer which can run on IIS. Please help me with installation mode document for IIS and windows Xp or Windows 2003 64 bit.
Appreciate your kind assistance.

Mostafiz