The WorksForWeb Community Forums
Welcome to the WorksForWeb community forums. Here you can discuss WorksForWeb products with others and contribute to the rapidly growing WorksForWeb community. Please note that while WorksForWeb staff try to maintain presence on the forums, this is not the most reliable way to contact WorksForWeb staff. In case you require a timely response from WorksForWeb on an issue, please open a support ticket here. For pre-sales questions, please open a sales ticket here.

Welcome, Guest. Please login or register.
May 18, 2012, 12:15:52 PM

Login with username, password and session length
Search:     Advanced search
Added the iLister-related Boards

Rate My Site Boards Added

Merged iAuto and iRealty Support Forums together

Several new tips in the Tips and Tricks section
1,604 Posts in 625 Topics by 1,179 Members
Latest Member: bobsteam
* Home Help Search Login Register
+  The iAuto/iRealty/iLister Support Forum
|-+  iAuto and iRealty v.2.x - 3.x
| |-+  General iAuto Discussions
| | |-+  Installation issue at: Creating Base Tables		 « previous next »
Pages: [1] Print
Author Topic: Installation issue at: Creating Base Tables  (Read 3357 times)
highnote
Newbie
*

Karma: 1
Posts: 38


View Profile
« on: April 15, 2007, 07:48:44 PM »
I hit a stopping point while installing the software.

My configuration:  Apache/2.2.4 (Win32) PHP/4.4.4, MySQL Server 5.2

Cannot execute MySQL query: #1064 - You have an error in your SQL syntax near 'CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, PRIMARY KEY (`id`) )' at line 6

Had anyone seen this during the install?

Thanks,
Lou
Logged
pntkl
Newbie
*

Karma: 1
Posts: 7


View Profile
« Reply #1 on: April 15, 2007, 08:19:17 PM »
Hi Lou,

     I had this error, initially, during installation. After submitting a support issue, the issue was resolved by iAuto. I'm not totally sure, but I think the issue was resolved by using MySQL 4.x.

T.J.
Logged
highnote
Newbie
*

Karma: 1
Posts: 38


View Profile
« Reply #2 on: April 15, 2007, 11:36:55 PM »
T.J.
Thanks for the quick response.  I un-installed the MySQL Version 5.2 and loaded 4.1.22, however, I have the same error message.  Were there any other hints that you can think of?
Thanks,
Lou
Logged
pntkl
Newbie
*

Karma: 1
Posts: 7


View Profile
« Reply #3 on: April 16, 2007, 05:47:19 AM »
Lou,
     I'm not sure if this will help you, but this link suggests it might be a character set issue. http://drupal.org/node/61784 Thinking about this further, I believe I actually only experienced this error on a Windows environment. It was when I was setting up a development environment. I wish I could remember how I worked around this, but I'm not sure if I did. I ended up just doing all the work from the host. Tongue
Logged
highnote
Newbie
*

Karma: 1
Posts: 38


View Profile
« Reply #4 on: April 16, 2007, 08:12:21 AM »
T.J.
Thanks for the lead.  This points me in a clear direction.  My Windows environment is also just for Development.
I fear I may have screwed some things up with all of the installs/uninstalls etc... just to get the basic server/PHP/MySQL functions up and running.  At one point, a message stating that the mbstring extension was not found, but the error message disappearence was never root-caused.  The installation is also yielding warning messages about not finding "iconv" extension and "CURL" Library so I think something may still be confused.  I will keep pecking.
Thanks again.  I will follow up on this lead.
Regards,
Lou
Logged
highnote
Newbie
*

Karma: 1
Posts: 38


View Profile
« Reply #5 on: April 17, 2007, 09:23:31 AM »
I still have not solved this one. 
A support request is pending.
Thanks
Logged
Smart Girl
Administrator
Full Member
*****

Karma: 5
Posts: 224


View Profile
« Reply #6 on: April 18, 2007, 05:48:17 PM »
highnote,

I received your request, we will try to help you.
Logged
Classified Software by Worksforweb
highnote
Newbie
*

Karma: 1
Posts: 38


View Profile
« Reply #7 on: April 22, 2007, 07:40:00 PM »
The new db.sql that support.iauto sent me fixed this issue and allowed me to install on my local windows server.
Thanks
Logged
Smart Girl
Administrator
Full Member
*****

Karma: 5
Posts: 224


View Profile
« Reply #8 on: April 25, 2007, 05:12:17 PM »
We have released the patch for this issue:
http://forum.iautosoftware.com/index.php/topic,149.0.html
Logged
Classified Software by Worksforweb
Pages: [1] Print 
« previous next »
Jump to:  

Powered by MySQL Powered by PHP Classified Software by Worksforweb Powered by SMF 1.1.8 | SMF © 2006-2008, Simple Machines LLC Valid XHTML 1.0! Valid CSS!