It's been awhile since I've had issues with my favorite online app
I think the "client" meddled with the ftp/files or something, and broke the site.
I changed mysql PW, and uploaded the newest release.
Went through the upgrade processes, and in the end had this error:
The site itself displays the following:We detected some errors while running some diagnostics on your entered information:
-
ALTER TABLE serendipity_authors ADD COLUMN hashtype int(1);
/ No database selected
ALTER TABLE serendipity_authors CHANGE password password VARCHAR(64) NOT NULL;
/ No database selected
Your Serendipity installation is now upgraded to version 1.5.4
I tried from phpmydamin to update the DB file from the latest DB from the SQL folder in the downloaded upgrade, and got the following error in phpmyadmin:Query failed:
SELECT
e.id,
e.title,
e.timestamp,
e.comments,
e.exflag,
e.authorid,
e.trackbacks,
e.isdraft,
e.allow_comments,
e.last_modified,
a.realname AS author,
a.username AS loginname,
a.email
, e.body, e.extended
FROM
serendipity_entries AS e
LEFT JOIN serendipity_authors a
ON e.authorid = a.authorid
LEFT JOIN serendipity_entrycat ec
ON e.id = ec.entryid
LEFT JOIN serendipity_category c
ON ec.categoryid = c.categoryid
LEFT JOIN serendipity_authorgroups AS acl_a
ON acl_a.authorid = 0
LEFT JOIN serendipity_access AS acl_acc
ON ( acl_acc.artifact_mode = 'read'
AND acl_acc.artifact_type = 'category'
AND acl_acc.artifact_id = c.categoryid
)
WHERE isdraft = 'false' AND e.timestamp <= 1288983300 AND (
c.categoryid IS NULL
OR ( acl_acc.groupid = 0)
OR ( acl_acc.artifact_id IS NULL
)
)
GROUP BY e.id
ORDER BY timestamp DESC
LIMIT 15
/ No database selected
CREATE TABLE {PREFIX}authors(
realname varchar( 255 ) NOT NULL default '',
username varchar( 32 ) default NULL ,
PASSWORD varchar( 64 ) default NULL ,
authorid{AUTOINCREMENT}{ PRIMARY },
mail_comments int( 1 ) default '1',
mail_trackbacks int( 1 ) default '1',
email varchar( 128 ) NOT NULL default '',
userlevel int( 4 ) {UNSIGNED} NOT NULL default '0',
right_publish int( 1 ) default '1',
hashtype int( 1 ) default '0'
){UTF_8};
MySQL said: Documentation
#1064 - 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 '{PREFIX}authors (
realname varchar(255) NOT NULL default '',
username varcha' at line 1
BTW, hosted at godaddy.
Thanks for any insight in repairing.