Photopost Install Error

[Jim O]

I've seen some reference to this before but no clear solution.

I just install a clean vBulletin 4.1.1 board and Photopost 7.03 After what appears to be a successful installation, I get the message:

"You are not a valid administrator or moderator!"

Logged out and in several times - no change. I believe my cookie settings are correct.

On an unrelated note, I am running MySQL server 5.5.8. The install.php needed to be edited as "TYPE=" caused an error. Changing those statements to "ENGINE=" corrected that and the tables were created with the correct storage engines.

[Chuck S]

I would suggest rerunning the install and see if that helps correct anything but maybe make sure mysql is not STRICT MODE.

[Jim O]

I added

sql-mode="TRADITIONAL" to my my.cnf and restarted MySQL server and tried again. I got the following errors:

Step 3: MySQL error reported: [CREATE TABLE IF NOT EXISTS pp_users (userid int(25) NOT NULL auto_increment, usergroupid int(5) NOT NULL default '0', username varchar(30) NOT NULL default '', realname varchar(80) default NULL, password varchar(50) NOT NULL default '', email varchar(75) NOT NULL default '', homepage varchar(100) default NULL, icq varchar(50) default NULL, aim varchar(30) default NULL, yahoo varchar(30) default NULL, joindate int(25) NOT NULL default '0', posts int(20) NOT NULL default '0', birthday date NOT NULL default '0000-00-00', ipaddress varchar(18) default NULL, location varchar(100) default NULL, interests MEDIUMTEXT NULL DEFAULT NULL, occupation varchar(250) default NULL, bio MEDIUMTEXT NULL DEFAULT NULL, site VARCHAR(30) default NULL, offset SMALLINT(2) DEFAULT '0' NOT NULL, lastphoto INT( 12 ) NOT NULL DEFAULT '0', lastdate INT( 15 ) NOT NULL DEFAULT '0', views int(10) NOT NULL default '0', cellphone VARCHAR(255) DEFAULT NULL, title varchar(30) default NULL, signature varchar(250) default NULL, avatar varchar(120) default NULL, mature tinyint(1) NOT NULL default '1', invites int(6) NOT NULL default '0', accepts int(6) NOT NULL default '0', laston int(15) NOT NULL default '0', paypal VARCHAR(75) NOT NULL DEFAULT '', PRIMARY KEY (userid)) ENGINE=MyISAM]
Result: Invalid default value for 'birthday'
Database: mydb

Step 3: MySQL error reported: [INSERT INTO pp_currency VALUES (23,'Netherlands Antilles, Guilders/Florins','ANG','ƒ', '2')]
Result: Data too long for column 'name' at row 1
Database: mydb

[Chuck S]

Those look like standard strict mysql errors if you made a change restart the server and then try installing.

[Jim O]

Originally Posted by Chuck S

Those look like standard strict mysql errors if you made a change restart the server and then try installing.

Nope. I *had* restarted. But I deleted the Photopost tables, confirmed the line in my.cnf (sql-mode="TRADITIONAL"), and restarted again. Result was the same exact errors.

Commenting out that line from my.cnf and restarting the MySQL server allowed the tables to be created and absolutely no errors being thrown - of course using the modified install.php to make the SQL statements consistent with MySQL 5.5.x. The result is again, that I am locked out as an administrator.

[Chuck S]

Content visible to verified customers only.

well thats a very new mysql your using so I cant confirm anything but the error your noting is what I have been with mysql strict mode being set.

You can send site login data database the whole nine yards if you want me to take a look.

[Jim O]

Can't seem to send a PM:

vBulletin Message
Chuck S has chosen not to receive private messages or may not be allowed to receive private messages. Therefore you may not send your message to him/her.

If you are trying to send this message to multiple recipients, remove Chuck S from the recipient list and send the message again.

Is there another way?

Jim

[Chuck S]

You can sent all relative site information through the contact us link in the header for company contact.

As my forum signature states I do not provide support outside the normal parameters which are forum or email. Thanks

[Jim O]

Originally Posted by Chuck S

You can sent all relative site information through the contact us link in the header for company contact.

As my forum signature states I do not provide support outside the normal parameters which are forum or email. Thanks

I do really appreciate your attempts at helping me, but gee Chuck, and with all due respect, I read your signature, which states, and I quote (note the formatting which is mine):

Please do not PM me for support or sales questions. Thank you for your understanding.

My understanding of English led me to take that as you don't want questions via PM. I was attempting to send private login information, not to ask questions. Since your PM's are closed, your signature seems a bit superfluous.

A more appropriate signature might be:

My PM's are closed. If you need to send private information such as server login information, please do so at http://www.photopost.com/ppost_contact.pl. Thank you for your understanding.

That way slow webmasters like myself would understand your actual intent.

I will send all of the information via the method you recommend. Again, I appreciate your support here.

[Chuck S]

Once we recieve that I will let you know via that email what I find.