You are not logged in.

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

T-Dawg
Forum Fellow
From: Wilmington, NC
Registered: 2005-01-29
Posts: 2,734

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

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

Offline

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

Lone_Wolf
Member
From: Netherlands, Europe
Registered: 2005-10-04
Posts: 4,239

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

Looking good, DTW. thanks for all your effort.


Booting with apg Openrc, NOT systemd.
Automounting : not needed, i prefer pmount
Aur helpers : makepkg + my own local repo === rarely need them

Offline

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

profoX
Member
From: Belgium
Registered: 2006-04-13
Posts: 110
Website

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

!praise dtw


Collecting data is only the first step toward wisdom.
But sharing data is the first step toward community.

Offline

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

kozaki
Member
From: London >. < Paris
Registered: 2005-06-13
Posts: 638
Website

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

Penguin wrote:

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

+1 big_smile


Seeded week #28: Arch 25 gig (stock 12, Talking 1, Anywhere 11, Apricity 1)
Desktop @3.30GHz 8 gig RAM, Arch linux-ck
laptop1 Atom 2 gig RAM, Arch linux stock i686 (5+H battery smile) & 2: ARM Tegra K1 4 gig RAM, ChrOS
Atom Z520 2 gig RAM, OMV (Debian 7) kernel 3.16 bpo on SDHC | PGP Key: 0xFF0157D9

Offline

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

dtw
Forum Fellow
From: UK
Registered: 2004-08-03
Posts: 4,432
Website

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

Registration is broken

Offline

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

mezoko
Member
Registered: 2005-03-26
Posts: 310
Website

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

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


"The only thing we have to fear is fear itself." - Franklin D. Roosevelt

Offline

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

Lone_Wolf
Member
From: Netherlands, Europe
Registered: 2005-10-04
Posts: 4,239

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

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


Booting with apg Openrc, NOT systemd.
Automounting : not needed, i prefer pmount
Aur helpers : makepkg + my own local repo === rarely need them

Offline

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

_Gandalf_
Member
Registered: 2006-01-12
Posts: 735

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

@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 ??

Offline

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

dtw
Forum Fellow
From: UK
Registered: 2004-08-03
Posts: 4,432
Website

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

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.

Offline

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

iphitus
Forum Fellow
From: Melbourne, Australia
Registered: 2004-10-09
Posts: 4,927

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

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.

Offline

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

dtw
Forum Fellow
From: UK
Registered: 2004-08-03
Posts: 4,432
Website

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

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.

Offline

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

soloport
Member
Registered: 2005-03-01
Posts: 442

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

_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.)

Offline

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

_Gandalf_
Member
Registered: 2006-01-12
Posts: 735

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

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 smile

Offline

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

ozar
Member
From: USA
Registered: 2005-02-18
Posts: 1,681

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

_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.   :?


oz

Offline

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

dtw
Forum Fellow
From: UK
Registered: 2004-08-03
Posts: 4,432
Website

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

/relief

Offline

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

dtw
Forum Fellow
From: UK
Registered: 2004-08-03
Posts: 4,432
Website

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

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... wink

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')

Offline

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

iBertus
Member
From: Greenville, NC
Registered: 2004-11-04
Posts: 2,228

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

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).

Offline

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

Lone_Wolf
Member
From: Netherlands, Europe
Registered: 2005-10-04
Posts: 4,239

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

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'

Booting with apg Openrc, NOT systemd.
Automounting : not needed, i prefer pmount
Aur helpers : makepkg + my own local repo === rarely need them

Offline

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

dtw
Forum Fellow
From: UK
Registered: 2004-08-03
Posts: 4,432
Website

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

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

Offline

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

stavrosg
Member
From: Rhodes, Greece
Registered: 2005-05-01
Posts: 330
Website

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

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

Offline

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

dtw
Forum Fellow
From: UK
Registered: 2004-08-03
Posts: 4,432
Website

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

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

Offline

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

kps
Member
Registered: 2006-04-30
Posts: 30

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

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

Offline

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

fk
Member
From: Germany
Registered: 2006-04-29
Posts: 524

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

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

I can confirm, registration works successfully


Have you tried to turn it off and on again?

Offline

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

dtw
Forum Fellow
From: UK
Registered: 2004-08-03
Posts: 4,432
Website

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

Bonus - that's a start!

Offline

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

T-Dawg
Forum Fellow
From: Wilmington, NC
Registered: 2005-01-29
Posts: 2,734

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

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!!

Offline

Board footer

Powered by FluxBB