Categories Hierarchy

All new MODs released in our MOD Database will be announced in here. All support for released MODs needs to take place in here. No new MODs will be accepted into the MOD Database for phpBB2
Forum rules
READ: phpBB.com Board-Wide Rules and Regulations

On February 1, 2009 this forum will be set to read only as part of retiring of phpBB2.

Rating:

Excellent!
56
72%
Very Good
10
13%
Good
4
5%
Fair
1
1%
Poor
7
9%
 
Total votes: 78

mglink
Registered User
Posts: 8
Joined: Fri Dec 28, 2007 1:04 am

Re: Categories Hierarchy

Post by mglink »

Not compatible with Points System, Cash Mod and ADR Mod ?

If I install this mod manually without the version pré-installed ?

Excuse my english... u.u
danb00
Registered User
Posts: 1025
Joined: Sun Dec 15, 2002 9:41 pm
Location: Inside Mod:Extreme PHPBB
Contact:

Re: Categories Hierarchy

Post by danb00 »

There a version out that supports phpBB 2.0.23 yet?
phpBBModded.com - Modding phpBB
User avatar
Ptirhiik
Registered User
Posts: 7411
Joined: Mon Jan 06, 2003 10:36 pm
Contact:

Re: Categories Hierarchy

Post by Ptirhiik »

For CH 2.1.6g (the current version): http://ptifo.clanmckeen.com/viewtopic.php?t=9071
The next minor version (CH 2.1.6h) is on its way (the install description are currently under writing), and will be based for the full install on phpBB 2.0.23.
micmic
Registered User
Posts: 14
Joined: Thu Mar 08, 2007 9:07 pm

Re: Categories Hierarchy

Post by micmic »

I am having a HUGE problem right now. Apparently none of my guest can register, whatsoever. It goes up to the agreement of terms screen, then once you submit that it runs into a "SQL requests not achieved" error. :[

The same error sometimes appears during logging off, and always when you tick the "Log me on automatically each visit" box.

It was working fine a few months ago. And I havent really been tinkering with any other files except the themes and such. I really have no idea what could be wrong. Could you please help me out?

Thankyou. Its a great mod by the way. ;]
User avatar
Ptirhiik
Registered User
Posts: 7411
Joined: Mon Jan 06, 2003 10:36 pm
Contact:

Re: Categories Hierarchy

Post by Ptirhiik »

This sounds as being a damaged table. What is the exact message you are receiving ?
micmic
Registered User
Posts: 14
Joined: Thu Mar 08, 2007 9:07 pm

Re: Categories Hierarchy

Post by micmic »

General Error

SQL requests not achieved



thats it. Nothing after or before it. :S
micmic
Registered User
Posts: 14
Joined: Thu Mar 08, 2007 9:07 pm

Re: Categories Hierarchy

Post by micmic »

Image

This is what I get.. for all the problems I mentioned. :?
User avatar
Ptirhiik
Registered User
Posts: 7411
Joined: Mon Jan 06, 2003 10:36 pm
Contact:

Re: Categories Hierarchy

Post by Ptirhiik »

So go to includes/class_config.php, and uncomment (eg remove "//" in front of) the "define('DEBUG_..." lines to get more informations, and report.
micmic
Registered User
Posts: 14
Joined: Thu Mar 08, 2007 9:07 pm

Re: Categories Hierarchy

Post by micmic »

Ok, I did that. Uncommented all of the lines, uploaded the file...

and its still giving me the same thing for all the problems...? The same exact "General Error" and then "SQL requests not achieved" ???
User avatar
Ptirhiik
Registered User
Posts: 7411
Joined: Mon Jan 06, 2003 10:36 pm
Contact:

Re: Categories Hierarchy

Post by Ptirhiik »

Now being logged in with your admin profile, go to your "profile/Registration information". Hit "create" to open the new user registration form, and create one: you should get a more detailed message, and the list of the requests ran at bottom of the page.
micmic
Registered User
Posts: 14
Joined: Thu Mar 08, 2007 9:07 pm

Re: Categories Hierarchy

Post by micmic »

The layout I have now isnt giving me any reports on the bottom. Ill try anotherone. :?
Last edited by micmic on Sat Mar 15, 2008 8:27 pm, edited 1 time in total.
micmic
Registered User
Posts: 14
Joined: Thu Mar 08, 2007 9:07 pm

Re: Categories Hierarchy

Post by micmic »

Ok, i tried changing the layout, and I got this report on the bottom of the page when I tried to manually create the User as you told me to:
[ Time: 0.6549s ][ Queries: 10 (0.0831s) - db: 9 (0.0829s) - cache: 1 (0.0002s/0.0149s) ][ GZIP on ]
class_config.php
Line: 172
db: 0.0142s
Request
SELECT config_name, config_value FROM nuke_bbconfig WHERE config_static = 0
Id Select type Table Type Possible keys Used key Key length Ref. Rows Comment
1 SIMPLE nuke_bbconfig ref config_static config_static 2 const 16 Using where

class_config.php
Line: 196
db: 0.0080s
Request
SELECT config_name, config_value FROM nuke_bbconfig WHERE config_static = 1
Id Select type Table Type Possible keys Used key Key length Ref. Rows Comment
1 SIMPLE nuke_bbconfig ref config_static config_static 2 const 134

class_custom_title.php
Line: 80
cache: 0.0002s
db: 0.0149s
Request
SELECT * FROM nuke_bbcustom_title_config
Id Select type Table Type Possible keys Used key Key length Ref. Rows Comment
1 SIMPLE nuke_bbcustom_title_config ALL 4

class_user_session.php
Line: 605
db: 0.0180s
Request
SELECT u.*, g.*, s.* FROM nuke_bbusers u, nuke_bbsessions s LEFT JOIN nuke_bbgroups g ON g.group_user_id = s.session_user_id WHERE s.session_id = '989fdf057cafa9d3b37a4ef0e0a3f240' AND s.session_time >= 1205602803 AND u.user_id = s.session_user_id AND (u.user_active = 1 OR u.user_id = -1) ORDER BY s.session_time DESC LIMIT 1
Id Select type Table Type Possible keys Used key Key length Ref. Rows Comment
1 SIMPLE s const PRIMARY,session_user_id,session_id_ip_user_id PRIMARY 32 const 1
1 SIMPLE u const PRIMARY,uid PRIMARY 3 const 1
1 SIMPLE g ref group_user_id group_user_id 3 const 12

class_user.php
Line: 37
db: 0.0012s
Request
SELECT * FROM nuke_bbthemes ORDER BY style_name
Id Select type Table Type Possible keys Used key Key length Ref. Rows Comment
1 SIMPLE nuke_bbthemes ALL 4 Using filesort

class_cp.php
Line: 242
db: 0.0064s
Request
SELECT * FROM nuke_bbcp_panels ORDER BY panel_order
Id Select type Table Type Possible keys Used key Key length Ref. Rows Comment
1 SIMPLE nuke_bbcp_panels ALL 38 Using filesort

class_cp.php
Line: 1049
db: 0.0013s
Request
SELECT * FROM nuke_bbcp_patches ORDER BY patch_id
Id Select type Table Type Possible keys Used key Key length Ref. Rows Comment
1 SIMPLE nuke_bbcp_patches ALL 5 Using filesort

class_user.php
Line: 1028
db: 0.0142s
Request
SELECT cache_id, cache_data, cache_time FROM nuke_bbusers_cache WHERE user_id = 3 AND cache_id IN('g', 'm', 'glist')
Id Select type Table Type Possible keys Used key Key length Ref. Rows Comment
1 SIMPLE nuke_bbusers_cache range PRIMARY PRIMARY 8 3 Using where

class_cp.php
Line: 465
db: 0.0187s
Request
SELECT * FROM nuke_bbcp_fields WHERE panel_id = 12 ORDER BY field_order
Id Select type Table Type Possible keys Used key Key length Ref. Rows Comment
1 SIMPLE nuke_bbcp_fields ref panel_id panel_id 3 const 1 Using where; Using filesort

class_visual_confirm.php
Line: 36
db: 0.0010s
Request
DELETE FROM nuke_bbconfirm WHERE session_id NOT IN( SELECT DISTINCT session_id FROM nuke_bbsessions WHERE session_logged_in = 1 OR session_user_id = -1 )
Hope this can help you solve the problem with this. :]

But on top it still have me the "General Error SQL requests not achieved" message.
User avatar
Ptirhiik
Registered User
Posts: 7411
Joined: Mon Jan 06, 2003 10:36 pm
Contact:

Re: Categories Hierarchy

Post by Ptirhiik »

With all the debugs activated, you don't have a more explicit message, with the failing request ? If so, ensure at top of includes/constants.php that the "define('DEBUG'" line uses 1 or true (default is 1). All other requests preceeding the failing one (so the list at bottom) sound ok.
micmic
Registered User
Posts: 14
Joined: Thu Mar 08, 2007 9:07 pm

Re: Categories Hierarchy

Post by micmic »

Thanks for all of your help! I have actually figured out the problem. :] Apparently I was missing a table like you said, the "confirm" table. I fixed it up, and added it in, and now it works! ^^

Thankyou again for your help. ;] And Once again, the mod is awsome!! :]
User avatar
Ptirhiik
Registered User
Posts: 7411
Joined: Mon Jan 06, 2003 10:36 pm
Contact:

Re: Categories Hierarchy

Post by Ptirhiik »

You're welcome :).
Post Reply

Return to “[2.0.x] MOD Database Releases”