Fodi at Baldninja.com

Fodi: The Forums => Technical Issues => Topic started by: Steve on August 18, 2006, 10:56:11 PM

Title: Help! Error messages.
Post by: Steve on August 18, 2006, 10:56:11 PM

Ok, so you might notice some change in the forums. We're now upgraded to the latest version of phpbb. The only thing is, a couple database tables got broken during the backup/restore.

Right now, it looks like the "search" functions are all that is still broken, but I'm too tired to deal with it tonight. I'll do it tomorrow.

If anyone gets an error, can they just copy the message and post it to this thread? That way, I can make sure to fix it all.

Title: Help! Error messages.
Post by: The Dark Agent on August 21, 2006, 01:55:56 AM

This is The Agent speaking...

Just got this one when trying to post a new topic

Code: [Select]

Error geting users post stat

DEBUG MODE

SQL Error : 1054 Unknown column 'g.group_count' in 'field list'

SELECT ug.user_id, g.group_id as g_id, u.user_posts, g.group_count, g.group_count_max FROM phpbb_groups g, phpbb_users u LEFT JOIN phpbb_user_group ug ON g.group_id=ug.group_id AND ug.user_id=9 WHERE u.user_id=9 AND g.group_single_user=0 AND g.group_count_enable=1 AND g.group_moderator<>9

Line : 463
File : functions_post.php

Title: Help! Error messages.
Post by: Shawna on August 21, 2006, 11:31:39 PM

Quote from: "The Dark Agent"

This is The Agent speaking...

Just got this one when trying to post a new topic

Code: [Select]

Error geting users post stat

DEBUG MODE

SQL Error : 1054 Unknown column 'g.group_count' in 'field list'

SELECT ug.user_id, g.group_id as g_id, u.user_posts, g.group_count, g.group_count_max FROM phpbb_groups g, phpbb_users u LEFT JOIN phpbb_user_group ug ON g.group_id=ug.group_id AND ug.user_id=9 WHERE u.user_id=9 AND g.group_single_user=0 AND g.group_count_enable=1 AND g.group_moderator<>9

Line : 463
File : functions_post.php

*sniff* That sorta stuff makes me miss my database systems class.  

The sad thing is, I understand that error.  :-P

Title: Help! Error messages.
Post by: Steve on August 22, 2006, 06:26:33 AM

Yep. I should actually remember to take care of this, but I've got to fix my car first. If only my car just needed some database work  :cry:

Title: Help! Error messages.
Post by: Lindsay on August 22, 2006, 06:41:17 AM

Go figure. I post a message about this and then an entirely new thread gets started after mine. I see how it is.  :raspberry:

Title: Help! Error messages.
Post by: Steve on August 22, 2006, 07:07:53 AM

Quote from: "Lindsay"

Go figure. I post a message about this and then an entirely new thread gets started after mine. I see how it is.  :raspberry:

Aww. But I posted before you did! People just responded here. I'm sorry. I'll go post in your thread.

Title: Help! Error messages.
Post by: Shawna on August 23, 2006, 12:52:47 AM

Quote from: "Steve"

Yep. I should actually remember to take care of this, but I've got to fix my car first. If only my car just needed some database work  :cry:

That'd be a hell of a car.  And very strange.  
select amount from car gas where car.gas = gas and car.name = 'Steves';

:-P