SQL Syntax Error

[Neil Batchelor]

I am trying to install this for the first time and I am coming up with SQL errors when moving to the third page.

5 Error: 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=MyISAM' at line 11

I receive notification after the errors that the tables have been correctly created but I can't move on from this point.

I am running:

Ubuntu Server 12.04

Apache 2.2.22

PHP 5.3.10

MySQL 5.5.28-0ubuntu0.12.04.2

All help greatly appreciated as this looks like a great project.

Neil

[Michael A Cooper]

Make sure you use the same use that you created the database with, I always us root and the pw for root in MySQL. It always seems to work better that way or if you are using some control panel whoever the site owner is that created the db. I ran into this very thing when I first used agilebill.

Hope this helps.

--
You received this message because you are subscribed to the Google Groups "AgileBill OSS Billing" group.
To view this discussion on the web visit https://groups.google.com/d/msg/agilebilloss/-/oOop1uVpT5UJ.
To post to this group, send email to agileb...@googlegroups.com.
To unsubscribe from this group, send email to agilebilloss...@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/agilebilloss?hl=en.

--

[Ad Aerts]

I have the same problem. When I look at the created database, all tables end with _id. For example the table that should have the name  ab_module has the name ab_module_id. This is definitely a bug. Who is going to solve it?

Op woensdag 5 december 2012 23:41:28 UTC+1 schreef Neil Batchelor het volgende:

[neen]

I will take a look at this later. However, I should note that the ab_module_id table is actually a separate table from the ab_module table.

Sent via BlackBerry by AT&T

---

From: Ad Aerts <ad.a...@gmail.com>

Sender: agileb...@googlegroups.com

Date: Wed, 12 Dec 2012 05:44:41 -0800 (PST)

To: <agileb...@googlegroups.com>

ReplyTo: agileb...@googlegroups.com

Subject: [agilebilloss] Re: SQL Syntax Error

--
You received this message because you are subscribed to the Google Groups "AgileBill OSS Billing" group.

To view this discussion on the web visit https://groups.google.com/d/msg/agilebilloss/-/ksWNCb8uWZsJ.

[William Rae]

I had the same problem with the installation process failing with this error. It has been a while since this post was created but I was able to correct the problem so thought I would share.

To fix this I went through the code and changed the 'TYPE=MyISAM' to 'ENGINE=MyISAM' and it created the tables without any issues.

This is a mySQL change for more recent versions and these are the files where you will find the 'Type=MyISAM' phrase.

install\install_db_core.inc
modules\module\module.inc.php

I hope this helps.

Bill