| Author |
Message |
unigene
Joined: Apr 07, 2005
Posts: 120
Location: Luxembourg
|
 Post subject: [fixed] cpg_error not shutting blocks down correctly
Posted: Sun Mar 09, 2008 12:51 pm |
 |
I need some help on an error which occurs when Users try to update their profile information.
Error:
Quote:
On /xyz/index.php?name=Your_Account
While executing query "SELECT g.group_id, g.group_name, g.group_type
FROM xyz_bbgroups g, xyz_bbuser_group ug
WHERE ug.user_id =
AND ug.group_id = g.group_id
AND ug.user_pending = 1
AND g.group_single_user = 0
ORDER BY g.group_name, ug.user_id"
In: /public_html/blocks/block-Groups.php on line: 50
The problem comes form the $userinfo['user_id'] which is blank.
When I insert a number like 2, the error disappears.
I compared the 9.2.1. block with the 9.1. block and this part is unchanged. Maybe I have to look somewhere else.
Can somebody please help me on this. Thanks
_________________
| Luxembourg Amateur Radio RL | RC Heli | My Site |
unigene's server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS)
Linux/ 2.6.18 / 5.1.52 / 5.3.2 / 9.3.2.0 |
|
| Back to top |
|
 |
unigene
Joined: Apr 07, 2005
Posts: 120
Location: Luxembourg
|
Post subject: Re: Error in query of Groups block: missing userinfo
Posted: Sun Mar 09, 2008 8:12 pm |
|
Looks as if I am the only one or did anyone else encounter this problem too?
_________________
| Luxembourg Amateur Radio RL | RC Heli | My Site |
unigene's server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS)
Linux/ 2.6.18 / 5.1.52 / 5.3.2 / 9.3.2.0 |
|
| Back to top |
|
|
mashed
Joined: Oct 18, 2006
Posts: 3
|
Post subject: Re: Error in query of Groups block: missing userinfo
Posted: Sun Mar 09, 2008 9:38 pm |
|
i got same problem mate... not found a fix yet though
_________________
.::Dark Omen::.
mashed's server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS)
MySQL version 4.1.21-standard |
|
| Back to top |
|
|
unigene
Joined: Apr 07, 2005
Posts: 120
Location: Luxembourg
|
Post subject: Re: Error in query of Groups block: missing userinfo
Posted: Mon Mar 10, 2008 8:56 am |
|
Thanks mashed. I'm glad that at least I'm not the only one.
How can I check that $userinfo[user_id] gets its value in that block. This value is used many times and seems to work in other modules/blocks.
unigene's server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS)
Linux/ 2.6.18 / 5.1.52 / 5.3.2 / 9.3.2.0 |
|
| Back to top |
|
|
NanoCaiordo
Joined: Jun 29, 2004
Posts: 3677
Location: Melbourne, AU
|
Post subject: Re: Error in query of Groups block: missing userinfo
Posted: Mon Mar 10, 2008 10:13 am |
|
Unless you are using a custom block, or unless some module or some other block is overwriting the $userinfo i have not clue why you get the error.
I've tried to test by having the groups block at first position on the left side and other combinations but it runs ok.
_________________
.:: I met php the 03 December 2003 :: Unforgettable day! ::.
NanoCaiordo's server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS)
MySQL 5.1 / PHP 5.3 / NextGen() |
|
| Back to top |
|
|
NanoCaiordo
Joined: Jun 29, 2004
Posts: 3677
Location: Melbourne, AU
|
Post subject: Re: Error in query of Groups block: missing userinfo
Posted: Mon Mar 10, 2008 12:14 pm |
|
Confirmed, working on it.
_________________
.:: I met php the 03 December 2003 :: Unforgettable day! ::.
NanoCaiordo's server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS)
MySQL 5.1 / PHP 5.3 / NextGen() |
|
| Back to top |
|
|
unigene
Joined: Apr 07, 2005
Posts: 120
Location: Luxembourg
|
Post subject: Re: Error in query of Groups block: missing userinfo
Posted: Mon Mar 10, 2008 12:23 pm |
|
Nano,
Now I found a site where it works. This site was upgraded using the first final 9.2.1 release. The first was the one released here bit with the missing documentation files. The others were upgraded using the release with the documentation included.
So I will check the difference between the files from both servers as I don't have the first release anymore. Maybe that there is a different file somewhere.
Can't it come from Your_Account (edit Profile) because it's here that it happens?
unigene's server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS)
Linux/ 2.6.18 / 5.1.52 / 5.3.2 / 9.3.2.0 |
|
| Back to top |
|
|
NanoCaiordo
Joined: Jun 29, 2004
Posts: 3677
Location: Melbourne, AU
|
Post subject: Re: [fixed] cpg_error not shutting blocks down correctly
Posted: Mon Mar 10, 2008 1:00 pm |
|
Thanks guys!
Bug is fixed, a proper bug report has been filled by me, changelog updated.
Bug #1033
Fix will get included in a bug fix release sheduled for the next weekend.
_________________
.:: I met php the 03 December 2003 :: Unforgettable day! ::.
NanoCaiordo's server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS)
MySQL 5.1 / PHP 5.3 / NextGen() |
|
| Back to top |
|
|
Forum FAQ
Search
Log in to check your private messages
Login
