Error message

[Anonymous]

I'm getting the error message "Error: You have an error in your SQL syntax near '; ' at line 13" after I fill in the "set password" form, before setting up the database. I've tried to tweak the code, but I'm pretty clueless. Any ideas?

[pixelpunk]

It's a fault in the syntax which reacts to older mysql installs.
For now you need to setup the table yourself via phpmyadmin or the likes.
I am really sorry about that, I am working to fix that problem as it is the number one issue when installing.

// punk

[Anonymous]

I am getting that error as well. Could you post the SQL query to run to set up the tables manually? It would be a big help to me

Thanks

hi, I extracted the SQL fromt he installscript:

CREATE TABLE pixelpost_config (
  admin varchar(20) NOT NULL default '',
  password varchar(90) NOT NULL default '',
  template varchar(150) NOT NULL default '',
  imagepath varchar(150) NOT NULL default '',
  siteurl varchar(100) NOT NULL default '',
  sitetitle varchar(100) NOT NULL default '',
  calendar varchar(30) NOT NULL default '',
  thumbwidth int(11) NOT NULL,
  thumbheight int(11) NOT NULL,
  compression int(11) NOT NULL
) TYPE=MyISAM;

CREATE TABLE pixelpost_categories (
  id int(11) NOT NULL auto_increment,
  name varchar(100) NOT NULL default '',
  KEY id (id)
) TYPE=MyISAM;

CREATE TABLE pixelpost_pixelpost (
  id int(11) NOT NULL auto_increment,
  datetime datetime NOT NULL default '0000-00-00 00:00:00',
  headline varchar(150) NOT NULL default '',
  body text NOT NULL,
  image text NOT NULL,
  category varchar(150) NOT NULL default '',
  KEY id (id)
) TYPE=MyISAM;


CREATE TABLE pixelpost_comments (
  id int(11) NOT NULL auto_increment,
  parent_id int(11) NOT NULL default '0',
  datetime datetime NOT NULL default '0000-00-00 00:00:00',
  ip varchar(20) NOT NULL default '',
  message text NOT NULL,
  name varchar(20) NOT NULL default '',
  url varchar(40) NOT NULL default '',
  KEY id (id)
) TYPE=MyISAM;

CREATE TABLE pixelpost_visitors (
  id int(11) NOT NULL auto_increment,
  datetime datetime NOT NULL default '0000-00-00 00:00:00',
  host varchar(100) NOT NULL default '',
  referer varchar(255) NOT NULL default '',
  ua varchar(255) NOT NULL default '',
  ip varchar(255) NOT NULL default '',
  ruri varchar(150) NOT NULL default '',
  PRIMARY KEY  (id)
) TYPE=MyISAM;

I just run it to test it and all tables were created

hope that helps,
Connie

[Rick]

Thanks a lot for your time Connie

[pixelpunk]

You also need to populate the pixelpost_config table, insert a row with relevant features. Bare in mind the password must be base64 encoded so leave that alone and login with a blank password.

I can give more help tomorrow on this

// punk

[Rick]

I did remove the password from the database table and I can login , but it won't upload any images, and I have check that the permissions are correct

[Anonymous]

You have an error in your SQL syntax near '; ' at line 13

[jmwicks]

The install.php code can be modified to get around this error by removing the ending ";" character in all of the mysql query strings. This will enable it to work (I think) on all versions of mysql. Example from line 76:

CREATE TABLE pixelpost_config (
  admin varchar(20) NOT NULL default '',
  password varchar(90) NOT NULL default '',
  template varchar(150) NOT NULL default '',
  imagepath varchar(150) NOT NULL default '',
  siteurl varchar(100) NOT NULL default '',
  sitetitle varchar(100) NOT NULL default '',
  calendar varchar(30) NOT NULL default '',
  thumbwidth int(11) NOT NULL,
  thumbheight int(11) NOT NULL,
  compression int(11) NOT NULL
) TYPE=MyISAM; <-- remove the ;

fixed version:

CREATE TABLE pixelpost_config (
  admin varchar(20) NOT NULL default '',
  password varchar(90) NOT NULL default '',
  template varchar(150) NOT NULL default '',
  imagepath varchar(150) NOT NULL default '',
  siteurl varchar(100) NOT NULL default '',
  sitetitle varchar(100) NOT NULL default '',
  calendar varchar(30) NOT NULL default '',
  thumbwidth int(11) NOT NULL,
  thumbheight int(11) NOT NULL,
  compression int(11) NOT NULL
) TYPE=MyISAM

[pixelpunk]

Thanks jmwicks, I did a few checks a couple of days ago and find out that was the trouble. Next version should install better on old mysql installs.

// punk