Mysql Error on
| Project: | helpdesk |
| Version: | HEAD |
| Component: | Code |
| Category: | bug report |
| Priority: | normal |
| Assigned: | Unassigned |
| Status: | won't fix |
Jump to:
When importing DB I get these errors.
"ERROR 1064 at line 24: 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 'CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
`atime` timest
"
"ERROR 1064 at line 24: 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 'DEFAULT CHARSET=latin1 COMMENT='Helpdesk Module: Start/Access/M
"
My Version of Mysql "mysql Ver 12.22 Distrib 4.0.24, for pc-linux-gnu (i386)"
Your version of helpdesk.mysql "-- MySQL dump 10.9
--
-- Copyright OSI 2005. Licensed under GPL version 2.
-- $Id: helpdesk.mysql,v 1.1 2006/01/17 19:55:10 fgm Exp $
--
-- Host: localhost Database: audeandrupal
-- ------------------------------------------------------
-- Server version 4.1.13-nt
I just grabbed the cvs version and gave it a shot.
#1
It looks like you're not using a version compatible with the current code. Which version of MySQL are you using ?
Beware: this module has been coded
- for 4.6.x only
- for PHP5.0.x only (uses version 5-specific class behaviours)
- for MySQL 4.1.x only
I'll definitely push it up to production level, but not right now. Although the module works (sort of) on this configuration, it still needs a lot (read: a lot !) of improvements before it reaches 1.0. Currently, it's more of a proof of concept than anything else.
Note that it could well be that the next version is redone completely differently, dropping the dependence on PHP5.0.x and MySQL 4.1.x, and being strictly 4.7 instead of 4.6. For this reason, I'm not fixing it in its current state. But if you can patch it and make it work, you're welcome :-)
#2
I was going by the requirments found in the install.html file included with the cvs version where it stated it needed 4.x. I'm currently using 4.0.24. I can't upgrade the version on the server I tested it with. I'll install it on a temporary machine that isn't being used as heavily and give it another shot. Maybe update the install.html file? :) If I have time I'll take a look at the mysql file and see if I can't make it backwards compatible.
"Version info: $Id: install.html,v 1.1 2006/01/17 19:55:10 fgm Exp $
Prerequisites
* drupal 4.6.x
* MySQL 4.x
* PHP 5.0.x
* The Drupal taxonomy.module installed and active