MYSQL Error at install

[Anonymous]

Hey there.

Trying to install and keep getting this error on the admin page after I enter in admin name and passwd:

Error: You have an error in your SQL syntax near '; ' at line 11

I have tried this with having a DB created beforehand and also to see if the script would create the DB. Neither work.


This is the first part of the script where it indicated there was an error:

<?php

// ################################################## ##
// PIXELPOST VERSION 1.1.2 - admin script | PHOTOBLOG PUNK SOFTWARE BY PUNK@PIXELPUNK.SE
// ################################################## ##

// admin.php version 1.3.2

require("pixelpost.php");
/* start up mysql */
mysql_connect($pixelpost_db_host, $pixelpost_db_user, $pixelpost_db_pass) || die("Error: ". mysql_error());
mysql_select_db($pixelpost_db_pixelpost) || die("Error: ". mysql_error());

// check to see if it's installed
$check = mysql_query("select * from pixelpost limit 0,1");
if(!$check) {
header("Location: install.php");
exit();
}

[pixelpunk]

It's a known error the script has with older MySQL, the syntax is wrong somewhere, I haven't put much time into it to be honest.

Quick solution is to manually create the tables as indicated by install.php.
Another solution is to update MySQL.

If you decide to manually create the tables don't forget that the password for admin are encoded.

Have a look at this thread:
http://www.pixelpunk.se/software/for...c&start=15

Hope it'll work out, let me know if I can be of any help.

// punK

[Anonymous]

Thanks.

Got the tables created, but a little lost with the meaning of this:

If that is the problem, open the table and insert a new password.

Code:
YWRtaW4=


The above is admin. You can change your password once you've logged in, so no worries.

What does code mean?

Thanks

kev

[pixelpunk]

Originally Posted by Anonymous

YWRtaW4=

Never mind the Code: thing.
Edit your table and insert the above YWRtaW4=, then when you login your password is admin.

Hope it works // punK

[Anonymous]

This is the last try and i'll stop buggin you!! Not a DB guy, sorry. Not sure where in the pixelpost_config table to add that.

Add that in the password field?

Field name
Data type Warning! Changing type may result in data loss
Type width
Type options Case insensitive Case sensitive
Allow nulls? Yes No
Default value
Part of primary key? Yes No

Or somewhere here:


Field name Type Allow nulls? Key Default value Extras
admin varchar(20) No None
password varchar(20) No None
template varchar(150) No None
imagepath varchar(150) No None
siteurl varchar(100) No None
sitetitle varchar(100) No None
calendar varchar(30) No None
version varchar(10) No None

Thanks for your help. Taking donations?

:?:

[pixelpunk]

Don't stop bug me until it's done, I don't like when pixelpost is acting up and ruining the experience for those who downloads it.

Can you enter sql somewhere, do you use phpmyadmin?
If so enter this query:

update pixelpost_config set password='YWRtaW4='

That should work, not tested though.
In the table pixelpost_config there is a column/field called password, that is the one we want to change.

// punk

Edit: Donations? Good idea. I want a postcard!

[Anonymous]

worked!!!!!

Thanks dude!

[flashlight]

I'm having the same problem. I know just enough to really get myself in trouble. Using phpMyAdmin, I pasted:

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

into the SQL query box under the SQL tab. I got the following error message:

Error


SQL-query*:*


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


MySQL said:


#1064 - You have an error in your SQL syntax near '$query = mysql_query( "
CREATE TABLE pixelpost_categories (
id int(11) NOT NU' at line 1


I've installed pixelpost successfully on another server, but am over my head here. Any advice would be most appreciated.

Thanks,

[turnover]

just past

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

[flashlight]

Ah yes, it's so obvious once you know the answer...

Thanks