You did run upgrade.php? What messages did it give?
For those three tables, I guess you somehow had $shoutstable, $pollstable and $pollvotestable in your config.php already even though they aren't in any of my 4.0 versions. So you'd have to manually edit config.php to remove those three lines first.
upgrade.php didn't throw any errors at me that I could tell. You're right about having those 3 tables in there. I also saw an error about wsnlinks_quotes too.
I'll remove those from the config.php file and re-run the script and let you know if anything else shows up.
wrote: I can't even get thru the first screen for upgrading. Encountered the error -
Cannot write to the file temp/current.tar.gz! You must chmod it to 666
Did I miss anything?
Rgds, Alvin.
If your FTP info isn't supplied and PHP is running as an apache module, you have two choices: 1) Uncheck the "upgrade templates" box when upgrading. 2) Manually create a temp directory and chmod it to 777.
Any chance we can have betting debugging information. I don't even know what order clause, what the existing data is or anything else useful for me to try and track this one down.
I have to look for all the order by settings and then try and see if any tables have any of those settings.
Now in classes/database.php at line 249 I added the following:
if (($debug>0) && ($debug<4)) echo "$table $fields $where $order $limit<br>";
resulting in:
phpbb_users id username='nigelreed' OR user_email='nigelreed'
I have no idea where id came from because it's nothing in my integration file, so I'm putting this down to a coding problem with the integration system Let me know if you want me to try anything.
Does it have a MySQL warning? If so I need that context. If not it could be random garbage output of the last error it had, not a current one, and meaningless.
Are you using the admin side login or the user side login? The user side is better, the admin side might not give a proper debug. Anyhow please post the actual full output from your screen.
Now, I go into my admin panel and change integration to phpBB2. I click save settings and it refreshes and tells me I am not logged into so I try to login: It just goes back to the login page. So, I go back to the homepage and try to login from the login block. I get "The password you supplied does not match the one for that username."
I turn on debugging by setting conent=2 where name='debug' in the settings table. When I try to login I get this:
Load time so far: 0.1 seconds.
Load time so far: 0.1 seconds.
Load time so far: 0.13 seconds.
Load time so far: 0.15 seconds.
Load time so far: 0.15 seconds.
Load time so far: 0.15 seconds.
Load time so far: 0.15 seconds.
Unknown column 'id' in 'field list'
username is nigelreed for user id number
Load time so far: 0.19 seconds.
Load time so far: 0.23 seconds.
Load time so far: 0.28 seconds.
Load time so far: 0.28 seconds.
Load time so far: 0.28 seconds.
Load time so far: 0.29 seconds.
Load time so far: 0.29 seconds.
Load time so far: 0.29 seconds.
Load time so far: 0.29 seconds.
Load time so far: 0.29 seconds.
Load time so far: 0.35 seconds.
Load time so far: 0.35 seconds.
If I turn off intengration by setting content='' where name='integration' in the settings file, I can log back in again.
So, the question is, why does my integration file work with 4.0.39 and not with 4.1.0?
There were no SQL errors displayed during any of this.
I turn on debugging by setting conent=2 where name='debug' i
I don't know what you expect the value 2 to do, but you should be using 1. 2 may do nothing or blow up the universe, since it's not even an option in the debug list and so has no defined behavior. Presumably it existed once upon a time, probably 2.x era, and was removed.
Anyhow by installing phpBB2 I can see the mysql warning that you don't see, and will take it from here.
Fixed for 4.1.2.
0/5
1
2
3
4
5
This thread is closed, so you cannot post a reply.
Comments on All sorts of problems after upgrade
Usergroup: Customer
Joined: Jul 17, 2003
Total Topics: 39
Total Comments: 100
I was running 4.0.39 and got an email about 4.1.0 so did an upgrade.
Followed the instructions, overwrote all the files except /integration/ and deleted the admin and images directories from templates.
I was using phpBB integration before. Now I cannot login either using my phpBB login or my original wsnlinks login.
I changed debugging to 2 by updating the wsnlinks_settings table and it doesn't show any mysql queries but it does show some errors.
Table 'phpBB_britnet_fm.wsnlinks_shouts' doesn't exist
Table 'phpBB_britnet_fm.wsnlinks_polls' doesn't exist
Table 'phpBB_britnet_fm.wsnlinks_pollvotes' doesn't exist
Missing fields all over the place too.
I've tried clearing cookies but no joy. Open to suggestions.
[update] I had to revert back to 4.0.39 since I can't have my site down. Please let me know if you want me to try anything.
Thanks
Nigel
I can't even get thru the first screen for upgrading. Encountered the error -
Cannot write to the file temp/current.tar.gz! You must chmod it to 666
Did I miss anything?
Rgds,
Alvin.
developer
Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California
Total Topics: 61
Total Comments: 7868
You did run upgrade.php? What messages did it give?
For those three tables, I guess you somehow had $shoutstable, $pollstable and $pollvotestable in your config.php already even though they aren't in any of my 4.0 versions. So you'd have to manually edit config.php to remove those three lines first.
Usergroup: Customer
Joined: Jul 17, 2003
Total Topics: 39
Total Comments: 100
upgrade.php didn't throw any errors at me that I could tell.
You're right about having those 3 tables in there. I also saw an error about wsnlinks_quotes too.
I'll remove those from the config.php file and re-run the script and let you know if anything else shows up.
Usergroup: Customer
Joined: Jul 17, 2003
Total Topics: 39
Total Comments: 100
I suppose I should ask - anything else I should remove before attempting to upgrade again? Here's my config.php with db/pw stuff removed.
<?php
$categoriestable = 'wsnlinks_categories';
$linkstable = 'wsnlinks_links';
$metatable = 'wsnlinks_settings';
$commentstable = 'wsnlinks_comments';
$memberstable = 'wsnlinks_members';
$membergroupstable = 'wsnlinks_membergroups';
$sessionstable = 'wsnlinks_sessions';
$emailtable = 'wsnlinks_email';
$ratingstable = 'wsnlinks_ratings';
$switchestable = 'wsnlinks_switches';
$pmtable = 'wsnlinks_pm';
$markuptable = 'wsnlinks_markup';
$imtable = 'wsnlinks_im';
$pollstable = 'wsnlinks_polls';
$modtable = 'wsnlinks_modlog';
$attachmentstable = 'wsnlinks_attachments';
$pollvotestable = 'wsnlinks_pollvotes';
$shoutstable = 'wsnlinks_shouts';
$quotestable = 'wsnlinks_quotes';
$helpcatstable = 'wsnlinks_helpcategory';
$helpitemstable = 'wsnlinks_helpitem';
$databasename = 'phpBB_britnet_fm';
$prefix = 'wsnlinks_';
$dbtype = 'mysql';
require_once 'databases/mysql.php';
$dbhost = 'localhost';
$adb = new db($dbhost, $dbuser, $dbpass, $databasename);
if ($adb->dbh) $connection = $adb->dbh;
?>
<?php $cronstable = 'wsnlinks_crons'; ?>
<?php $searchestable = 'wsnlinks_searches'; $caltable = 'wsnlinks_calendar'; $in
vitestable = 'wsnlinks_invites'; $traderstable = 'wsnlinks_trader';
$dirurl = 'http://dir.british-expats.com';
$uploadpath = '/var/www/britnet/public_html/attachments/';
$rejectspiderlevel = '20';
$rejectguestlevel = '';
$ftphost = '';
$ftpuser = '';
$ftppass = '';
$ftpdir = '';
?>
Usergroup: Customer
Joined: Jul 17, 2003
Total Topics: 39
Total Comments: 100
OK, I had another go. The upgrade went without any problems and just gave a list of templates that have changed.
I was able to use the admin panel. If I logout of the admin panel and then try to login to the system again, by setting debug=2, I get the following.
Unknown column 'id' in 'field list' while trying to login. Just viewing the list shows
Unknown column 'id' in 'order clause'
Also, SEO fails to work with the new .htaccess file. I just get page not found. It works with the old one.
Regards
Nigel
developer
Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California
Total Topics: 61
Total Comments: 7868
Do you see those messages normally, or only when you turn debug mdde on?
Unknown column 'id' in 'order clause'
This probably means you have members sorted by a field which phpBB doesn't have. Go to Admin -> Settings -> General and select a member sort order.
You're submitting Admin -> Settings -> SEO? What are your settings there?
developer
Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California
Total Topics: 61
Total Comments: 7868
I can't even get thru the first screen for upgrading. Encountered the error -
Cannot write to the file temp/current.tar.gz! You must chmod it to 666
Did I miss anything?
Rgds,
Alvin.
If your FTP info isn't supplied and PHP is running as an apache module, you have two choices:
1) Uncheck the "upgrade templates" box when upgrading.
2) Manually create a temp directory and chmod it to 777.
Usergroup: Customer
Joined: Jul 17, 2003
Total Topics: 39
Total Comments: 100
Do you see those messages normally, or only when you turn debug mdde on?
Unknown column 'id' in 'order clause'
This probably means you have members sorted by a field which phpBB doesn't have. Go to Admin -> Settings -> General and select a member sort order.
You're submitting Admin -> Settings -> SEO? What are your settings there?
I just get the error in debug mode. I'll have to figure out how to get into the admin without being able to login.
I'll tell you my SEO options once I get there.
Thanks,
Nigel
Usergroup: Customer
Joined: Jul 17, 2003
Total Topics: 39
Total Comments: 100
Any chance we can have betting debugging information. I don't even know what order clause, what the existing data is or anything else useful for me to try and track this one down.
I have to look for all the order by settings and then try and see if any tables have any of those settings.
Thanks,
Nigel
Usergroup: Customer
Joined: Jul 17, 2003
Total Topics: 39
Total Comments: 100
OK, I turned off integration and debug
update wsnlinks_settings set content='' where name='integration'
update wsnlinks_settings set content='0' where name='debug'
Still can't login. Turn on debug...
clear cookies and this time I get:
Unknown column 'user_id' in 'field list'
Can you tell me exactly where "field list" comes from and what I can put in there to make it work so I can login?
And the big question is - why does all this work in 4.0.39 and not 4.1.0 ?
Usergroup: Customer
Joined: Jul 17, 2003
Total Topics: 39
Total Comments: 100
Right, upon further investigation upon a new install...Created in integration file and selected it within wsnlinks.
in classes/members.php I added this section at line 361
if (($debug > 0) && ($debug <4)) {
echo "npw: " . $newpassword;
echo "<br>nla: " . $newlastattempt;
echo "<br>nun: " . $newname;
echo "<br>nwl: " . $newemail;
echo "<br>";
}
The result is:
npw: user_password
nla: lastattempt
nun: username
nwl: user_email
table: phpbb_users
This shows all my fields are correct.
Now in classes/database.php at line 249 I added the following:
if (($debug>0) && ($debug<4)) echo "$table $fields $where $order $limit<br>";
resulting in:
phpbb_users id username='nigelreed' OR user_email='nigelreed'
I have no idea where id came from because it's nothing in my integration file, so I'm putting this down to a coding problem with the integration system
Regards
Nigel
developer
Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California
Total Topics: 61
Total Comments: 7868
I don't even know what order clause
This one: http://www.webmastersite.net/screenshots/839.jpg
Unknown column 'user_id' in 'field list'
Does it have a MySQL warning? If so I need that context. If not it could be random garbage output of the last error it had, not a current one, and meaningless.
Are you using the admin side login or the user side login? The user side is better, the admin side might not give a proper debug. Anyhow please post the actual full output from your screen.
Usergroup: Customer
Joined: Jul 17, 2003
Total Topics: 39
Total Comments: 100
OK. Completely fresh install again.
Honestly, I don't touch a thing in any of the settings. Fresh install.
I copy over my php integration file into integration/phpbb.php which works on 4.0.39
<?php
$memberstable = 'phpbb_users';
$newid = 'user_id';
$newname = 'username';
$newpassword = 'user_password';
$newusergroup = 'user_level';
$newtime = 'user_regdate';
$newemail = 'user_email';
$otherencoder = 'no';
$admingroup = '1';
$idcookiename = 'britnetcookie';
$passwordcookiename = '';
$cookietype = '';
$idindex = '';
$passwordindex = '';
?>
And yes, this does work on 4.0.39
Now, I go into my admin panel and change integration to phpBB2. I click save settings and it refreshes and tells me I am not logged into so I try to login: It just goes back to the login page. So, I go back to the homepage and try to login from the login block. I get "The password you supplied does not match the one for that username."
I turn on debugging by setting conent=2 where name='debug' in the settings table. When I try to login I get this:
Load time so far: 0.1 seconds.
Load time so far: 0.1 seconds.
Load time so far: 0.13 seconds.
Load time so far: 0.15 seconds.
Load time so far: 0.15 seconds.
Load time so far: 0.15 seconds.
Load time so far: 0.15 seconds.
Unknown column 'id' in 'field list'
username is nigelreed for user id number
Load time so far: 0.19 seconds.
Load time so far: 0.23 seconds.
Load time so far: 0.28 seconds.
Load time so far: 0.28 seconds.
Load time so far: 0.28 seconds.
Load time so far: 0.29 seconds.
Load time so far: 0.29 seconds.
Load time so far: 0.29 seconds.
Load time so far: 0.29 seconds.
Load time so far: 0.29 seconds.
Load time so far: 0.35 seconds.
Load time so far: 0.35 seconds.
If I turn off intengration by setting content='' where name='integration' in the settings file, I can log back in again.
So, the question is, why does my integration file work with 4.0.39 and not with 4.1.0?
There were no SQL errors displayed during any of this.
Thanks,
Nigel
Attached Files:
developer
Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California
Total Topics: 61
Total Comments: 7868
I turn on debugging by setting conent=2 where name='debug' i
I don't know what you expect the value 2 to do, but you should be using 1. 2 may do nothing or blow up the universe, since it's not even an option in the debug list and so has no defined behavior. Presumably it existed once upon a time, probably 2.x era, and was removed.
Anyhow by installing phpBB2 I can see the mysql warning that you don't see, and will take it from here.
Fixed for 4.1.2.