Installation problem

[ingouk]

hi,

just tried to install pixelpost 1.1.2
after typing in the username and password at the installation iget this:
Error: You have an error in your SQL syntax near '; ' at line 11

My mysql version is: 3.23.58 (stock redhat 9)
Do i have to upgrade mysql?

Cheers

Ingo

[pixelpunk]

Hi,

sorry to hear you run into trouble. Yes, I believe it's the mysql version that is a bit outdated and thus causing the fatal error.

Are you familiar with MySQL you can have a look in the install.php file to see how the tables are setup and create them yourself.

Otherwise you might consider updating your MySQL. Redhat 9 has been out for awhile hasn't it? I might be mistaken, anyway, a newer MySQL version will sort it out. I am not sure what changes in the syntax MySQL has done so I can't tell you to do this and that to fix it, unfortunately.

Third and last option would be to let me in and work it til it's been done. That would however require you to give me access to the whole shebang and most people don't want to hand that over to strangers, even though I consider myself a good guy.

Hope it resolves in any way, let me know if you need any guidance. I will help to the best of my abilities.

// pixelpunk

[ingouk]

yep, updating mysql to 4.0.21-standard helped.
ur right redhat 9 has been our for a while.
It works really fine, but what i miss is creating just a text entry without an image.

http://www.ibosse.org (test version)

[pixelpunk]

That was fast!
I'm happy it worked out for you.

For the text entry only thing.
This is intended to be a photoblog, a small niche I admit. I made it because even if there are gazillions of them text blogs out there, none seemed to be appropriate for photoblogging. Or so I've heard anyway
I myself have a tendency to re-invent the wheel all over every time i do something, I write my own stuff. That's why I wrote up this and released it.

As stated on the front page: if writing is your thing, pixelpost is not for you.

A text only entry hasn't even crossed my mind, to be honest.

Cheers // 72 pixels

[ingouk]

I want to mainly use it for photos, but i might just post something without a photo on a slow day. But i think a 1pixel jpg might do the trick.

[pixelpunk]

I totally understand the text entry thing.

For myself I sometimes (as now) wished I could post a small entry stating why I'm slow on updates and such. Would be good to have, but for now it's not there and I can't see it in the future either!

<77 punk

[ingouk]

I am going to try out if the 1pixel jpg or transparant gif works.
If it works, just provide pixelpost with the transparent gif or 1pixel jpg allready in the images section.

Ingo

[Anonymous]

i too have the same problem.

is there any way of doing this without updating the mysql? my web host is a bastard and wont do it. does anyone have the mysql queries on a txt file that i could just pump into phpmysql?

cheers

tom

[pixelpunk]

Here's what the install script does:

CREATE TABLE pixelpost_config (
  admin varchar(20) NOT NULL default '',
  password varchar(20) 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 '',
  version varchar(10) NOT NULL default ''
) TYPE=MyISAM;


// this will populate the config table. all is changeable later in the admin panel
INSERT INTO pixelpost_config VALUES ('youradminname', 'youradminpass, 'pixelpost-light', 'absolutepathtoimages', 'yoursiteurl', 'pixelpost','','NULL');

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

// insert a default category
INSERT INTO pixelpost_categories VALUES ('NULL', 'default');

CREATE TABLE 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;

Copy/pasted from the install.php.

Hope it will work out, let me know if I can help in any way.

// punk

[Anonymous]

Hi,

I have a syntax error when i installed your script.

I created in my base mysql this install code.

But whats the login and password (default) please ?

Thx and good work for your script. Its simple, nice.

Cheers