attach mod problem

New Member Joined: Dec 28, 2003 Posts: 3

hello i have phpnuke 6.7 and attach mod on it.
when i transferd the phpbb db to nuke all was ok.
than...
i transferd attach mod tabels and all went wrong
when i enter the topics on forum i get this:

Quote:

Failed obtaining forum access control lists

DEBUG MODE

SQL Error : 1054 Unknown column 'a.auth_download' in 'field list'

SELECT a.forum_id, a.auth_view, a.auth_read, a.auth_post, a.auth_reply, a.auth_edit, a.auth_delete, a.auth_sticky, a.auth_announce, a.auth_vote, a.auth_pollcreate, a.auth_attachments, a.auth_download, a.auth_mod FROM nuke_bbauth_access a, nuke_bbuser_group ug WHERE ug.user_id = 2 AND ug.user_pending = 0 AND a.group_id = ug.group_id AND a.forum_id = 1

Line : 194
File : /var/www/html/gilad26/nuke/includes/auth.php

can it be solved?
thanks
gilad

Site Admin/Owner Joined: Aug 27, 2002 Posts: 17088

It looks like you haven't transferred the tables correctly. It is expecting to see a column called auth_download in the nuke_bbauth_access table.

Posted: Thu Jan 01, 2004 11:06 am

the first 1 was solved but i still get an error massege:

Quote:

Could not obtain topic information

DEBUG MODE

SQL Error : 1054 Unknown column 'f.auth_download' in 'field list'

SELECT t.topic_id, t.topic_title, t.topic_status, t.topic_replies, t.topic_time, t.topic_type, t.topic_vote, t.topic_last_post_id, f.forum_name, f.forum_status, f.forum_id, f.auth_view, f.auth_read, f.auth_post, f.auth_reply, f.auth_edit, f.auth_delete, f.auth_sticky, f.auth_announce, f.auth_pollcreate, f.auth_vote, f.auth_attachments, f.auth_download, t.topic_attachment FROM nuke_bbtopics t, nuke_bbforums f WHERE t.topic_id = 1251 AND f.forum_id = t.forum_id

Line : 188
File : /var/www/html/gilad26/nuke/modules/Forums/viewtopic.php

i bealive its becouse i changed the AUTO_INCREMENT in users table
can it be solved?