[forums] URGENT - READ! Updated to 2.0.20

T-Dawg · 2006-04-17 01:32:20

Looks as good as new. We appreciate your time on this

Lone_Wolf · 2006-04-17 08:51:04

Looking good, DTW. thanks for all your effort.

profoX · 2006-04-17 09:02:27

!praise dtw

kozaki · 2006-04-18 23:28:17

Penguin wrote:

Looks as good as new. We appreciate your time on this

+1

dtw · 2006-04-19 09:19:34

Registration is broken

mezoko · 2006-04-20 19:09:21

You call php 2.0.2 an upgrade? I call it a downgrade!

Lone_Wolf · 2006-04-20 19:13:27

phpBB is the software this forum is running on and that sw just went to version 2.0.20 .

_Gandalf_ · 2006-04-21 08:20:11

@dtw it seems there's a problem with the session life time, everywhile i have to login manually though i have selected "Remember me", has anyone else noticed this ??

dtw · 2006-04-21 10:44:50

msg43 wrote:

You call php 2.0.2 an upgrade? I call it a downgrade!

Yeah...read before you flame - it makes you look less of an asshat.

iphitus · 2006-04-21 11:14:38

dtw wrote:

msg43 wrote:
You call php 2.0.2 an upgrade? I call it a downgrade!
Yeah...read before you flame - it makes you look less of an asshat.

And returning fire drags you to the same level too.

dtw · 2006-04-21 12:59:09

Indeed, alas, such pointless and lazy flammage brings out the worst in me, especially when it is with regard to something I have worked hard on. The fact that it is still broken, despite my best efforts during my Easter break, adds to the irksome nature of such commentary.

soloport · 2006-04-21 17:09:30

_Gandalf_ wrote:

@dtw it seems there's a problem with the session life time, everywhile i have to login manually though i have selected "Remember me", has anyone else noticed this ??

Sorry to report: "Remember me" is working, here. Haven't had to log in for over a week (AFAICR). Have cookies off? (Just a shot in the dark.)

_Gandalf_ · 2006-04-21 19:31:04

No cookies are on of course, anywya today it seems is handling quite well am not sure wether it's opera 9 problem or this forum update anyway if i had any furthure logout issues i'll post here

ozar · 2006-04-21 19:51:02

_Gandalf_ wrote:

everywhile i have to login manually though i have selected "Remember me", has anyone else noticed this ??

Haven't noticed that happening at all here - "remember me" seems to be working fine.

I have noticed that the feature/option isn't working where you can keep new posts in certain forums from showing up in the "view posts since last visit" search. It was working fine before the upgrade but seems to be gone now. :?

dtw · 2006-04-22 11:29:12

/relief

dtw · 2006-04-22 12:37:28

OK, the fix is beyond me and my limited server access. I believe the fix requires sql intervention from the Judd. I have emailed him and hopefully my suggestion will work.

However, in the meantime, if anyone can check the following error to see what the mismatches is i.e. how many fields are there versus values to fill them, that'd be great...

SQL Error : 1136 Column count doesn't match value count at row 1

INSERT INTO phpbb_users (user_id, username, user_regdate, user_password, user_email, user_icq, user_website, user_occ, user_from, user_interests, user_sig, user_sig_bbcode_uid, user_avatar, user_avatar_type, user_viewemail, user_aim, user_yim, user_msnm, user_attachsig, user_allowsmile, user_allowhtml, user_allowbbcode, user_allow_viewonline, user_notify, user_notify_pm, user_popup_pm, user_timezone, user_dateformat, user_lang, user_style, user_level, user_allow_pm, user_active, user_actkey) VALUES (5938, 'testuser-monkeyboy', 1145707296, 'fa820cc1ad39a4e99283e9fa555035ec', '780223@myrealbox.com', '', '', '', '', '', '', '', '', 0, 0, '', '', '', '', 1, 1, 1, 1, 1, 0, 1, 1, -6, 'D M d, Y g:i a', 'asc', 'english', 1, 0, 1, 0, '4ac6cb716114ea91ac')

iBertus · 2006-04-22 18:11:17

I count 34 fields and 36 values. Also, some of the values don't seem to match the field. For example, date format is 29th value but 28th field. You seem to be just missing 2 fields.

What is the 'asc' that is 30th in values? Doesn't seem to have anything listed in fields (between dateformat and lang).

Lone_Wolf · 2006-04-23 11:15:52

Here's a breakdown of the sql statement.
I've compared it with my profile info, and it looks like the Yabber address field is missing. It should probably be in the user_aim, user_yim, user_msnm part.

As iBertus mentioned there is also something wrong at the bottom, starting with user_dateformat.

user_id                5938
username            'testuser-monkeyboy'
user_regdate            1145707296
user_password            'fa820cc1ad39a4e99283e9fa555035ec'
user_email            '780223@myrealbox.com'
user_icq            ''
user_website            ''
user_occ            ''
user_from            ''
user_interests            ''
user_sig            ''
user_sig_bbcode_uid        ''
user_avatar            ''
user_avatar_type        0
user_viewemail            0
user_aim            ''
user_yim            ''
user_msnm            ''
user_attachsig            ''
user_allowsmile            1
user_allowhtml            1
user_allowbbcode        1
user_allow_viewonline        1
user_notify            1
user_notify_pm            0
user_popup_pm            1
user_timezone            1
user_dateformat            -6
user_lang            'D M d, Y g:i a'
user_style            'asc'
user_level            'english'
user_allow_pm            1
user_active            0
user_actkey            1
                0
                '4ac6cb716114ea91ac'

dtw · 2006-04-24 08:55:40

Ahhh, thanks lads. That's helped tons. I threw that post up as my battery was dying on my laptop at my local hotspot.

The asc is from post_sort_order, which you can't see. So the missing fields are the jabber_id and post_sort - I'll fix that no problem.

Cheers guys1

stavrosg · 2006-04-25 17:41:22

One more thingy - forum codepage went ISO8859-1, and international characters posting broke.

For example, the next line should have contained greek characters:
Δοκιμή

Surprisingly, older posts do show up fine

dtw · 2006-04-29 15:46:37

ok - i have made some tweakage and some problems now seem fixed. Could people check previous problems and report back? Ta.

kps · 2006-04-30 15:25:27

The registration problem seems solved now.
At least I registered successfully.

fk · 2006-04-30 18:29:23

The registration problem seems solved now.
At least I registered successfully.

I can confirm, registration works successfully

dtw · 2006-05-01 16:30:17

Bonus - that's a start!

T-Dawg · 2006-05-01 20:42:42

hey dibble.......

Error getting user list for group
DEBUG MODE
SQL Error : 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 ' AND ug.user_id <> 118 ORDER BY u.username' at line 6
SELECT u.username, u.user_id, u.user_viewemail, u.user_posts, u.user_regdate, u.user_from, u.user_website, u.user_email, u.user_icq, u.user_aim, u.user_yim, u.user_msnm, u.user_jabber, ug.user_pending FROM phpbb_users u, phpbb_user_group ug WHERE ug.group_id = 3498 AND u.user_id = ug.user_id AND ug.user_pending = 0 ` AND ug.user_id <> 118 ORDER BY u.username
Line : 787
File : groupcp.php

haha.

hahahahahhaha.

MUHAHAHAHAHAHAHAHHAAHAH!!

Arch Linux

#26 2006-04-17 01:32:20

Re: [forums] URGENT - READ! Updated to 2.0.20

#27 2006-04-17 08:51:04

Re: [forums] URGENT - READ! Updated to 2.0.20

#28 2006-04-17 09:02:27

Re: [forums] URGENT - READ! Updated to 2.0.20

#29 2006-04-18 23:28:17

Re: [forums] URGENT - READ! Updated to 2.0.20

#30 2006-04-19 09:19:34

Re: [forums] URGENT - READ! Updated to 2.0.20

#31 2006-04-20 19:09:21

Re: [forums] URGENT - READ! Updated to 2.0.20

#32 2006-04-20 19:13:27

Re: [forums] URGENT - READ! Updated to 2.0.20

#33 2006-04-21 08:20:11

Re: [forums] URGENT - READ! Updated to 2.0.20

#34 2006-04-21 10:44:50

Re: [forums] URGENT - READ! Updated to 2.0.20

#35 2006-04-21 11:14:38

Re: [forums] URGENT - READ! Updated to 2.0.20

#36 2006-04-21 12:59:09

Re: [forums] URGENT - READ! Updated to 2.0.20

#37 2006-04-21 17:09:30

Re: [forums] URGENT - READ! Updated to 2.0.20

#38 2006-04-21 19:31:04

Re: [forums] URGENT - READ! Updated to 2.0.20

#39 2006-04-21 19:51:02

Re: [forums] URGENT - READ! Updated to 2.0.20

#40 2006-04-22 11:29:12

Re: [forums] URGENT - READ! Updated to 2.0.20

#41 2006-04-22 12:37:28

Re: [forums] URGENT - READ! Updated to 2.0.20

#42 2006-04-22 18:11:17

Re: [forums] URGENT - READ! Updated to 2.0.20

#43 2006-04-23 11:15:52

Re: [forums] URGENT - READ! Updated to 2.0.20

#44 2006-04-24 08:55:40

Re: [forums] URGENT - READ! Updated to 2.0.20

#45 2006-04-25 17:41:22

Re: [forums] URGENT - READ! Updated to 2.0.20

#46 2006-04-29 15:46:37

Re: [forums] URGENT - READ! Updated to 2.0.20

#47 2006-04-30 15:25:27

Re: [forums] URGENT - READ! Updated to 2.0.20

#48 2006-04-30 18:29:23

Re: [forums] URGENT - READ! Updated to 2.0.20

#49 2006-05-01 16:30:17

Re: [forums] URGENT - READ! Updated to 2.0.20

#50 2006-05-01 20:42:42

Re: [forums] URGENT - READ! Updated to 2.0.20

Board footer