SQL error after update

Started by llamabox, August 24, 2010, 04:38:30 PM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

llamabox

My forum has not even been set-up. Just 1-2 sections added and only the 2 admin working on it are registered. So no real loss if I have to start over. But I can't even get to it. With my bookmark I can access the admin CP. Since the forum hasn't been finished I haven't made a back-up to be able to try the restore option.

http://cannaseedcollective.noonhost.com/

But I am able to access specific threads in there is a link to it in my history. Like this one.
http://cannaseedcollective.noonhost.com/rules-for-your-enjoyment-vf2.html

[B]General Error[/B]

            SQL ERROR [ mysql4 ]

Unknown column 'g.group_skip_auth' in 'where clause' [1054]

SQL

SELECT  ug.user_id, a.forum_id, a.auth_setting, a.auth_option_id,  ao.auth_option             FROM cannaseedcollective_noonhost_com_acl_groups a,  cannaseedcollective_noonhost_com_user_group ug,  cannaseedcollective_noonhost_com_groups g,  cannaseedcollective_noonhost_com_acl_options ao             WHERE a.auth_role_id = 0 AND a.auth_option_id = ao.auth_option_id                  AND a.group_id = ug.group_id                 AND g.group_id = ug.group_id                 AND ug.user_pending = 0                 AND NOT (ug.group_leader = 1 AND g.group_skip_auth = 1)                                                   AND ao.auth_option IN ('a_', 'm_')

BACKTRACE

[B]FILE:[/B] includes/db/mysql.php
[B]LINE:[/B] 174
[B]CALL:[/B] dbal->sql_error()

[B]FILE:[/B] includes/auth.php
[B]LINE:[/B] 637
[B]CALL:[/B] dbal_mysql->sql_query()

[B]FILE:[/B] includes/auth.php
[B]LINE:[/B] 351
[B]CALL:[/B] auth->acl_raw_data()

[B]FILE:[/B] blocks/block_the_team.php
[B]LINE:[/B] 34
[B]CALL:[/B] auth->acl_get_list()

[B]FILE:[/B] includes/portal_blocks.php
[B]LINE:[/B] 99
[B]CALL:[/B] include_once('blocks/block_the_team.php')

[B]FILE:[/B] portal.php
[B]LINE:[/B] 43
[B]CALL:[/B] include_once('includes/portal_blocks.php')

[B]FILE:[/B] home.php
[B]LINE:[/B] 17
[B]CALL:[/B] include('portal.php')

kimgold2010

We do apologize for any inconvenience you are having. I have fixed a problem that you've encountered. You please try again and let me know if you have any another problems.

Thank you.
Feel free to contact us if you have any questions.

Thank you