Search found 10 matches

by afx114
Tue Jun 29, 2004 12:40 am
Forum: 2.0.x Support Forum
Topic: Avatar larger than max allowed?
Replies: 4
Views: 142

I have "Enable remote avatars" set to NO, but it still lets users specify a remote avatar. Why is this?
by afx114
Mon Jun 28, 2004 11:45 pm
Forum: 2.0.x Support Forum
Topic: Avatar larger than max allowed?
Replies: 4
Views: 142

Avatar larger than max allowed?

My users are able to upload avatars larger than the 80x80 I have specified in the config. Also, I have "Enable remote avatars" set to NO in my config, but the dialog is still presented to the users. How is this possible? I've looked in the database itself, in the phpbb_config table, and the settings...
by afx114
Fri Feb 13, 2004 5:08 pm
Forum: [2.0.x] MOD Database Cleanup
Topic: [2.0.6] Prune User Posts
Replies: 110
Views: 48204

Re changing the default checkings, well "All Users" is not checked by default. A confirmation box might be useful indeed. Yes, All Users is not checked by default, but I think a lot of people will be using this mod to do things like: "Delete all posts prior to dd/mm/yyyy" When using the mod in this...
by afx114
Thu Feb 12, 2004 9:24 pm
Forum: [2.0.x] MOD Database Cleanup
Topic: [2.0.6] Prune User Posts
Replies: 110
Views: 48204

Queries

Queries on form page: SELECT * FROM phpbb_config SELECT u.*, s.* FROM phpbb_sessions s, phpbb_users u WHERE s.session_id = '014da822b28d25132118ff374aabf88b' AND u.user_id = s.session_user_id UPDATE phpbb_sessions SET session_time = 1076619523, session_page = 0 WHERE session_id = '014da822b28d251321...
by afx114
Thu Feb 12, 2004 8:45 pm
Forum: [2.0.x] MOD Database Cleanup
Topic: [2.0.6] Prune User Posts
Replies: 110
Views: 48204

P.S., that is a NOT NULL column in the DB, so a row with NULL in that column cannot be inserted.
by afx114
Thu Feb 12, 2004 8:44 pm
Forum: [2.0.x] MOD Database Cleanup
Topic: [2.0.6] Prune User Posts
Replies: 110
Views: 48204

R45 wrote: Can you try

Code: Select all

SELECT * FROM phpbb_posts WHERE forum_id IS NULL
And see if you get any problems?


0 rows returned.
by afx114
Thu Feb 12, 2004 8:14 pm
Forum: [2.0.x] MOD Database Cleanup
Topic: [2.0.6] Resync User Post Counts
Replies: 81
Views: 39081

Spellcheck

Found a bug, errr... typo:
You can Press the resync button to resync all the post counts to their true figure by recounting the amound of actual posts they made.


"amound" should be "amount"

:)
by afx114
Thu Feb 12, 2004 7:22 pm
Forum: [2.0.x] MOD Database Cleanup
Topic: [2.0.6] Prune User Posts
Replies: 110
Views: 48204

Okay, could not reproduce error. The only way this could happen is if your forums table has some bad entries OR a post in your database has an invalid forum entry in a post record, at first glance. I'll do some more code testing, but do you have any MODs on your forum? Nope, no other MODs. I looked...
by afx114
Thu Feb 12, 2004 12:12 am
Forum: [2.0.x] MOD Database Cleanup
Topic: [2.0.6] Prune User Posts
Replies: 110
Views: 48204

Sure enough, I turned set "Adjust Post Counts" to NO and everything runs as planned without the PHP error. Looks like there's a bug in that SQL:

SELECT COUNT(post_id) as numrows FROM phpbb_posts WHERE forum_id =

forum_id is not defined.
by afx114
Wed Feb 11, 2004 11:59 pm
Forum: [2.0.x] MOD Database Cleanup
Topic: [2.0.6] Prune User Posts
Replies: 110
Views: 48204

Bug

I am getting the following error: phpBB : Critical Error Could not select posts count forum total DEBUG MODE SQL Error : 1064 You have an error in your SQL syntax near '' at line 3 SELECT COUNT(post_id) as numrows FROM phpbb_posts WHERE forum_id = Line : 1191 File : /path/to/phpBB2/admin/admin_prune...

Go to advanced search