admin interface 'incomplete' post upgrade,blog not displayin

[subgeometer]

Hi Garvin,

the same line is still throwing an error, so similar I made sure I hadn't actually copied the wrong file:


Parse error: syntax error, unexpected T_STRING in /home/httpd/html/socialistpartyaustralia/council/serendipity/recovery3.php on line 12

Would it be simpler to pass in these queries directly via the mysql shell, substituting the values out of config_local.inc.php. I might try that, but not before educating myself a little about mysql/SQL. The mysql version is...

johno@foobuntu:~/Desktop/gnulib_src$ ssh $SPAT mysql --version
socialistpartyaustralia@socialistpartyaustralia.org's password:
mysql Ver 14.12 Distrib 5.0.32, for pc-linux-gnu (i486) using readline 5.2

Thanks again

Johno

[garvinhicking]

Hi!

Hm, somehow an error slipped into there again, I'm sorry.

This is the code I've made sure throws no errors:

Code: Select all

<?php
include 'serendipity_config.inc.php';
$username = 'steve';

$auth = serendipity_db_query("SELECT * FROM {$serendipity['dbPrefix']}authors WHERE username = '$username'");
print_r($auth);

foreach($auth AS $idx => $author) {
  print_r(serendipity_db_query("SELECT * FROM {$serendipity['dbPrefix']}config WHERE authorid = '" . $author['authorid'] . '"'));
}

serendipity_db_query("UPDATE {$serendipity['dbPrefix']}authors SET userlevel = 255, right_publish = 1 WHERE username = '$username'");
serendipity_db_query("UPDATE {$serendipity['dbPrefix']}config SET value = '0' WHERE name = 'no_create'");

Best regards,
Garvin

[subgeometer]

Garvin,

Ok, here's the output:


Array ( [0] => Array ( [0] => steve [realname] => steve [1] => steve [username] => steve [2] => d192e88f76e612f114c668d38b4ad9c9 [password] => d192e88f76e612f114c668d38b4ad9c9 [3] => 2 [authorid] => 2 [4] => 0 [mail_comments] => 0 [5] => 0 [mail_trackbacks] => 0 [6] => JollyS@yarracity.vic.gov.au [email] => JollyS@yarracity.vic.gov.au [7] => 255 [userlevel] => 255 [8] => 1 [right_publish] => 1 ) )

SELECT * FROM serendipity_config WHERE authorid = '2"

/ 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 ''2"' at line 1


Is this password information usable by someone?

Actually I changed your script with an explicit variable
$authorsteve = $author['authorid'];
to get around the insane quoting between php and mysql' shell

giving output as follows:

Array ( [0] => Array ( [0] => steve [realname] => steve [1] => steve [username] => steve [2] => d192e88f76e612f114c668d38b4ad9c9 [password] => d192e88f76e612f114c668d38b4ad9c9 [3] => 2 [authorid] => 2 [4] => 0 [mail_comments] => 0 [5] => 0 [mail_trackbacks] => 0 [6] => JollyS@yarracity.vic.gov.au [email] => JollyS@yarracity.vic.gov.au [7] => 255 [userlevel] => 255 [8] => 1 [right_publish] => 1 ) ) Array ( [0] => Array ( [0] => template [name] => template [1] => [value] => [2] => 0 [authorid] => 0 ) [1] => Array ( [0] => dbType [name] => dbType [1] => mysql [value] => mysql [2] => 0 [authorid] => 0 ) [2] => Array ( [0] => dbHost [name] => dbHost [1] => localhost [value] => localhost [2] => 0 [authorid] => 0 ) [3] => Array ( [0] => dbUser [name] => dbUser [1] => socialistpartyau [value] => socialistpartyau [2] => 0 [authorid] => 0 ) [4] => Array ( [0] => dbPass [name] => dbPass [1] => yPebWd62 [value] => yPebWd62 [2] => 0 [authorid] => 0 ) [5] => Array ( [0] => dbName [name] => dbName [1] => socialistpartyaustralia [value] => socialistpartyaustralia [2] => 0 [authorid] => 0 ) [6] => Array ( [0] => dbPrefix [name] => dbPrefix [1] => serendipity_ [value] => serendipity_ [2] => 0 [authorid] => 0 ) [7] => Array ( [0] => serendipityPath [name] => serendipityPath [1] => /home/httpd/html/socialistpartyaustralia/council/serendipity/ [value] => /home/httpd/html/socialistpartyaustralia/council/serendipity/ [2] => 0 [authorid] => 0 ) [8] => Array ( [0] => uploadPath [name] => uploadPath [1] => uploads/ [value] => uploads/ [2] => 0 [authorid] => 0 ) [9] => Array ( [0] => serendipityHTTPPath [name] => serendipityHTTPPath [1] => /council/serendipity/ [value] => /council/serendipity/ [2] => 0 [authorid] => 0 ) [10] => Array ( [0] => templatePath [name] => templatePath [1] => templates/ [value] => templates/ [2] => 0 [authorid] => 0 ) [11] => Array ( [0] => uploadHTTPPath [name] => uploadHTTPPath [1] => uploads/ [value] => uploads/ [2] => 0 [authorid] => 0 ) [12] => Array ( [0] => baseURL [name] => baseURL [1] => http://www.socialistpartyaustralia.org/ ... rendipity/ [value] => http://www.socialistpartyaustralia.org/ ... rendipity/ [2] => 0 [authorid] => 0 ) [13] => Array ( [0] => indexFile [name] => indexFile [1] => diary.php [value] => diary.php [2] => 0 [authorid] => 0 ) [14] => Array ( [0] => user [name] => user [1] => [value] => [2] => 0 [authorid] => 0 ) [15] => Array ( [0] => pass [name] => pass [1] => [value] => [2] => 0 [authorid] => 0 ) [16] => Array ( [0] => email [name] => email [1] => andrew@hugeobject.com [value] => andrew@hugeobject.com [2] => 0 [authorid] => 0 ) [17] => Array ( [0] => want_mail [name] => want_mail [1] => [value] => [2] => 0 [authorid] => 0 ) [18] => Array ( [0] => allowSubscriptions [name] => allowSubscriptions [1] => true [value] => true [2] => 0 [authorid] => 0 ) [19] => Array ( [0] => blogTitle [name] => blogTitle [1] => [value] => [2] => 0 [authorid] => 0 ) [20] => Array ( [0] => lang [name] => lang [1] => en [value] => en [2] => 0 [authorid] => 0 ) [21] => Array ( [0] => wysiwyg [name] => wysiwyg [1] => false [value] => false [2] => 0 [authorid] => 0 ) [22] => Array ( [0] => XHTML11 [name] => XHTML11 [1] => false [value] => false [2] => 0 [authorid] => 0 ) [23] => Array ( [0] => enablePopup [name] => enablePopup [1] => false [value] => false [2] => 0 [authorid] => 0 ) [24] => Array ( [0] => embed [name] => embed [1] => true [value] => true [2] => 0 [authorid] => 0 ) [25] => Array ( [0] => top_as_links [name] => top_as_links [1] => false [value] => false [2] => 0 [authorid] => 0 ) [26] => Array ( [0] => blockReferer [name] => blockReferer [1] => ; [value] => ; [2] => 0 [authorid] => 0 ) [27] => Array ( [0] => rewrite [name] => rewrite [1] => rewrite [value] => rewrite [2] => 0 [authorid] => 0 ) [28] => Array ( [0] => magick [name] => magick [1] => false [value] => false [2] => 0 [authorid] => 0 ) [29] => Array ( [0] => convert [name] => convert [1] => /usr/bin/convert [value] => /usr/bin/convert [2] => 0 [authorid] => 0 ) [30] => Array ( [0] => thumbSuffix [name] => thumbSuffix [1] => serendipityThumb [value] => serendipityThumb [2] => 0 [authorid] => 0 ) [31] => Array ( [0] => thumbSize [name] => thumbSize [1] => 110 [value] => 110 [2] => 0 [authorid] => 0 ) [32] => Array ( [0] => @serendipity_calendar_plugin:0774ae338c2cf54d9b30ff7822008666/beginningOfWeek [name] => @serendipity_calendar_plugin:0774ae338c2cf54d9b30ff7822008666/beginningOfWeek [1] => 1 [value] => 1 [2] => 0 [authorid] => 0 ) [33] => Array ( [0] => serendipity_plugin_recententries:029b4ded651ea8c03d301b74f8e8a645/number [name] => serendipity_plugin_recententries:029b4ded651ea8c03d301b74f8e8a645/number [1] => 10 [value] => 10 [2] => 0 [authorid] => 0 ) [34] => Array ( [0] => serendipity_plugin_recententries:029b4ded651ea8c03d301b74f8e8a645/dateformat [name] => serendipity_plugin_recententries:029b4ded651ea8c03d301b74f8e8a645/dateformat [1] => %A, %B %e %Y [value] => %A, %B %e %Y [2] => 0 [authorid] => 0 ) [35] => Array ( [0] => blogDescription [name] => blogDescription [1] => [value] => [2] => 0 [authorid] => 0 ) [36] => Array ( [0] => extCSS [name] => extCSS [1] => /council/serendipity/serendipity.css.php [value] => /council/serendipity/serendipity.css.php [2] => 0 [authorid] => 0 ) [37] => Array ( [0] => serendipity_event_nl2br:3b8ea70432cd6f98566f07af4a38ef5e/isolate [name] => serendipity_event_nl2br:3b8ea70432cd6f98566f07af4a38ef5e/isolate [1] => [value] => [2] => 0 [authorid] => 0 ) [38] => Array ( [0] => serendipity_plugin_recententries:029b4ded651ea8c03d301b74f8e8a645/number_from [name] => serendipity_plugin_recententries:029b4ded651ea8c03d301b74f8e8a645/number_from [1] => all [value] => all [2] => 0 [authorid] => 0 ) [39] => Array ( [0] => serendipity_plugin_recententries:029b4ded651ea8c03d301b74f8e8a645/randomize [name] => serendipity_plugin_recententries:029b4ded651ea8c03d301b74f8e8a645/randomize [1] => no [value] => no [2] => 0 [authorid] => 0 ) [40] => Array ( [0] => serendipity_event_spamblock:da307ab8edcca15f7c593b72ccf22b75/checkmail [name] => serendipity_event_spamblock:da307ab8edcca15f7c593b72ccf22b75/checkmail [1] => false [value] => false [2] => 0 [authorid] => 0 ) [41] => Array ( [0] => serendipity_event_spamblock:5c13cf002af73eec85c21ee7b5e56a51/checkmail [name] => serendipity_event_spamblock:5c13cf002af73eec85c21ee7b5e56a51/checkmail [1] => false [value] => false [2] => 0 [authorid] => 0 ) [42] => Array ( [0] => serendipity_event_trackexits:b61201145475c21224dc297b54d76cd7/commentredirection [name] => serendipity_event_trackexits:b61201145475c21224dc297b54d76cd7/commentredirection [1] => none [value] => none [2] => 0 [authorid] => 0 ) [43] => Array ( [0] => serendipity_event_trackexits:c98af13a4645a83346d89f03e1f77c4e/commentredirection [name] => serendipity_event_trackexits:c98af13a4645a83346d89f03e1f77c4e/commentredirection [1] => none [value] => none [2] => 0 [authorid] => 0 ) [44] => Array ( [0] => serendipity_event_spamblock:da307ab8edcca15f7c593b72ccf22b75/dbversion [name] => serendipity_event_spamblock:da307ab8edcca15f7c593b72ccf22b75/dbversion [1] => 2 [value] => 2 [2] => 0 [authorid] => 0 ) [45] => Array ( [0] => serendipity_event_spamblock:da307ab8edcca15f7c593b72ccf22b75/entrytitle [name] => serendipity_event_spamblock:da307ab8edcca15f7c593b72ccf22b75/entrytitle [1] => [value] => [2] => 0 [authorid] => 0 ) [46] => Array ( [0] => serendipity_event_spamblock:da307ab8edcca15f7c593b72ccf22b75/automagic_htaccess [name] => serendipity_event_spamblock:da307ab8edcca15f7c593b72ccf22b75/automagic_htaccess [1] => [value] => [2] => 0 [authorid] => 0 ) [47] => Array ( [0] => serendipity_event_spamblock:da307ab8edcca15f7c593b72ccf22b75/logtype [name] => serendipity_event_spamblock:da307ab8edcca15f7c593b72ccf22b75/logtype [1] => none [value] => none [2] => 0 [authorid] => 0 ) [48] => Array ( [0] => serendipity_event_spamblock:da307ab8edcca15f7c593b72ccf22b75/akismet [name] => serendipity_event_spamblock:da307ab8edcca15f7c593b72ccf22b75/akismet [1] => [value] => [2] => 0 [authorid] => 0 ) [49] => Array ( [0] => serendipity_event_spamblock:da307ab8edcca15f7c593b72ccf22b75/akismet_filter [name] => serendipity_event_spamblock:da307ab8edcca15f7c593b72ccf22b75/akismet_filter [1] => reject [value] => reject [2] => 0 [authorid] => 0 ) [50] => Array ( [0] => serendipity_event_spamblock:da307ab8edcca15f7c593b72ccf22b75/trackback_check_url [name] => serendipity_event_spamblock:da307ab8edcca15f7c593b72ccf22b75/trackback_check_url [1] => [value] => [2] => 0 [authorid] => 0 ) [51] => Array ( [0] => serendipity_event_spamblock:da307ab8edcca15f7c593b72ccf22b75/bloggdeblacklist [name] => serendipity_event_spamblock:da307ab8edcca15f7c593b72ccf22b75/bloggdeblacklist [1] => none [value] => none [2] => 0 [authorid] => 0 ) [52] => Array ( [0] => serendipity_event_spamblock:5c13cf002af73eec85c21ee7b5e56a51/dbversion [name] => serendipity_event_spamblock:5c13cf002af73eec85c21ee7b5e56a51/dbversion [1] => 2 [value] => 2 [2] => 0 [authorid] => 0 ) [53] => Array ( [0] => serendipity_event_spamblock:5c13cf002af73eec85c21ee7b5e56a51/entrytitle [name] => serendipity_event_spamblock:5c13cf002af73eec85c21ee7b5e56a51/entrytitle [1] => [value] => [2] => 0 [authorid] => 0 ) [54] => Array ( [0] => serendipity_event_spamblock:5c13cf002af73eec85c21ee7b5e56a51/automagic_htaccess [name] => serendipity_event_spamblock:5c13cf002af73eec85c21ee7b5e56a51/automagic_htaccess [1] => [value] => [2] => 0 [authorid] => 0 ) [55] => Array ( [0] => serendipity_event_spamblock:5c13cf002af73eec85c21ee7b5e56a51/logtype [name] => serendipity_event_spamblock:5c13cf002af73eec85c21ee7b5e56a51/logtype [1] => none [value] => none [2] => 0 [authorid] => 0 ) [56] => Array ( [0] => serendipity_event_spamblock:5c13cf002af73eec85c21ee7b5e56a51/akismet [name] => serendipity_event_spamblock:5c13cf002af73eec85c21ee7b5e56a51/akismet [1] => [value] => [2] => 0 [authorid] => 0 ) [57] => Array ( [0] => serendipity_event_spamblock:5c13cf002af73eec85c21ee7b5e56a51/akismet_filter [name] => serendipity_event_spamblock:5c13cf002af73eec85c21ee7b5e56a51/akismet_filter [1] => reject [value] => reject [2] => 0 [authorid] => 0 ) [58] => Array ( [0] => serendipity_event_spamblock:5c13cf002af73eec85c21ee7b5e56a51/trackback_check_url [name] => serendipity_event_spamblock:5c13cf002af73eec85c21ee7b5e56a51/trackback_check_url [1] => [value] => [2] => 0 [authorid] => 0 ) [59] => Array ( [0] => serendipity_event_spamblock:5c13cf002af73eec85c21ee7b5e56a51/bloggdeblacklist [name] => serendipity_event_spamblock:5c13cf002af73eec85c21ee7b5e56a51/bloggdeblacklist [1] => none [value] => none [2] => 0 [authorid] => 0 ) )


I hope this is helpful

Johno

[garvinhicking]

Hi!

Great, that helps at least a bit. I can see that the userlevel/right_publish colums in serendipity_Authors are set properly.

Now the serendipity_config table output only showed entries for authorid=0, I'd need it for authorid=2 (which is your id).

You could get that with this code:

Code: Select all

include 'serendipity_config.inc.php';
echo '<pre>';
foreach($auth AS $idx => $author) {
  print_r(serendipity_db_query("SELECT * FROM {$serendipity['dbPrefix']}config WHERE authorid = 2"));
}
echo '</pre>';

This should help me then see if the "no_publish" row is set accordingly.

Regards,
Garvin

[subgeometer]

Garvin, here's the output from the latest script.

Is it the last set of values that is hiding the configuration?

Johno

Array
(
[0] => Array
(
[0] => blogTitle
[name] => blogTitle
[1] => Councillor blog
[value] => Councillor blog
[2] => 2
[authorid] => 2
)

[1] => Array
(
[0] => blogDescription
[name] => blogDescription
[1] =>
[value] =>
[2] => 2
[authorid] => 2
)

[2] => Array
(
[0] => lang
[name] => lang
[1] => en
[value] => en
[2] => 2
[authorid] => 2
)

[3] => Array
(
[0] => wysiwyg
[name] => wysiwyg
[1] => false
[value] => false
[2] => 2
[authorid] => 2
)

[4] => Array
(
[0] => top_as_links
[name] => top_as_links
[1] => false
[value] => false
[2] => 2
[authorid] => 2
)

[5] => Array
(
[0] => username
[name] => username
[1] => steve
[value] => steve
[2] => 2
[authorid] => 2
)

[6] => Array
(
[0] => realname
[name] => realname
[1] => steve
[value] => steve
[2] => 2
[authorid] => 2
)

[7] => Array
(
[0] => email
[name] => email
[1] => JollyS@yarracity.vic.gov.au
[value] => JollyS@yarracity.vic.gov.au
[2] => 2
[authorid] => 2
)

[8] => Array
(
[0] => eyecandy
[name] => eyecandy
[1] => true
[value] => true
[2] => 2
[authorid] => 2
)

[9] => Array
(
[0] => mail_comments
[name] => mail_comments
[1] => false
[value] => false
[2] => 2
[authorid] => 2
)

[10] => Array
(
[0] => mail_trackbacks
[name] => mail_trackbacks
[1] => false
[value] => false
[2] => 2
[authorid] => 2
)

[11] => Array
(
[0] => moderateCommentsDefault
[name] => moderateCommentsDefault
[1] => false
[value] => false
[2] => 2
[authorid] => 2
)

[12] => Array
(
[0] => allowCommentsDefault
[name] => allowCommentsDefault
[1] => true
[value] => true
[2] => 2
[authorid] => 2
)

[13] => Array
(
[0] => publishDefault
[name] => publishDefault
[1] => publish
[value] => publish
[2] => 2
[authorid] => 2
)

[14] => Array
(
[0] => showMediaToolbar
[name] => showMediaToolbar
[1] => false
[value] => false
[2] => 2
[authorid] => 2
)

)

[garvinhicking]

Hi!

Okay, as it seems a config value is missing here. You can insert it with this SQL code:

Code: Select all

<?php
include 'serendipity_config.inc.php';

serendipity_db_query("INSERT INTO {$serendipity['dbPrefix']}config (name, value, authorid) VALUES ('right_publish', 'true', 2)");
serendipity_db_query("INSERT INTO {$serendipity['dbPrefix']}config (name, value, authorid) VALUES ('no_create', 'false', 2)");
serendipity_db_query("INSERT INTO {$serendipity['dbPrefix']}config (name, value, authorid) VALUES ('userlevel', '255', 2)");

HTH,
Garvin

[subgeometer]

Garvin,

sorry about the delay over Easter.

I ran the latest script, which has updated the config as shown by your formatted query script:

[15] => Array
(
[0] => right_publish
[name] => right_publish
[1] => true
[value] => true
[2] => 2
[authorid] => 2
)

[16] => Array
(
[0] => no_create
[name] => no_create
[1] => 0
[value] => 0
[2] => 2
[authorid] => 2
)

[17] => Array
(
[0] => userlevel
[name] => userlevel
[1] => 255
[value] => 255
[2] => 2
[authorid] => 2
)


However, on logging into steve's account, the situation is unchanged.

what next?

thanks

Johno

[garvinhicking]

Hi!

I'm a bit out of clues. If that hasn't done the job, I don't really know what's happening. Supposedly one of the updates might not have performed required DB updates properly.

I would need FTP access to that installation, else I can't really debug this issue especially with our posting frequency it would take a few months of ping-pong.

Regards,
Garvin

[subgeometer]

Garvin,

I have no objections to giving you access, but I'll have to ask first. Also I need an address to send the details. Thanks again for your assistance, I do greatly appreciate it.

Johno

[subgeometer]

Garvin,

Are there any extra arguments that need to be passed to mysqldump when backing up the database to ensure it is usable? I have backed it up but want to be sure of it.

regards

Johno

[garvinhicking]

Hi!

Sure, I have sent you a private board message on how to contact me.

For mysqldump, you should use "--complete-insert --compress --create-options --set-charset" for maximum compatibility to reimport later.

Regards,
Garvin