IPB

ISO Image Creator | Cheap EQ2 gold - Buy EQ2 gold, EVE ISK, EQ Plat and more!

Welcome Guest ( Log In | Register )

 
Reply to this topicStart new topic
> Links System 2.1.5, mySQL error help needed...
ssabo
post Jun 12 2005, 10:32 AM
Post #1


Newbie
Group Icon

Group: Members
Posts: 2
Joined: 23-March 04
From: Houston, Texas
Member No.: 10,769
 United States


I have tried adding your Links System 2.1.5 and everything seems to go well except and until I go to the ACP>Manage User Groups, and turn on all the buttons to “Yes” in the Links System Permission area, then click “Complete Edit”.

I receive the following mySQL error:


mySQL query error: UPDATE ibf_groups SET

mySQL error: Unknown column 'g_attach_per_post' in 'field list'


It would seem that this column ('g_attach_per_post') is missing in the “ibf_groups” table.

I am trying to install this mod onto a IPB(Trial) v2.0.0 PF 1.

Question: Can I just add the needed “column” to the “ibf_groups” table?

Or, is there an easier work around for this?

This column, I assume, is something that came after “PF1”. blink.gif

Thanks in advance, for any advice that will point me in the right direction of correcting this error
Go to the top of the page
 
+Quote Post
Dan.M
post Jun 12 2005, 03:52 PM
Post #2


Helpful Member
Group Icon

Group: Members
Posts: 51
Joined: 9-September 03
Member No.: 3,427
 Canada


This problem has nothing to do with the link system..

but u can try adding in the column by putting this in SQL Toolbox

CODE
ALTER TABLE 'ibf_groups' ADD 'g_attach_per_post' TINYINT( 1 ) DEFAULT '0' NOT NULL
Go to the top of the page
 
+Quote Post
ssabo
post Jun 12 2005, 06:29 PM
Post #3


Newbie
Group Icon

Group: Members
Posts: 2
Joined: 23-March 04
From: Houston, Texas
Member No.: 10,769
 United States


QUOTE(Dan.M @ Jun 12 2005, 03:52 PM)
This problem has nothing to do with the link system..

but u can try adding in the column by putting this in SQL Toolbox

CODE
ALTER TABLE 'ibf_groups' ADD 'g_attach_per_post' TINYINT( 1 ) DEFAULT '0' NOT NULL

*


Thanks Dan.M!

I had to change the code to match my version of mySQL, but other than that, it took care of the problem for me. Added the column and now Link Systems is UP & RUNNING.

Great Mod...fbarber
Go to the top of the page
 
+Quote Post
bfarber
post Jun 13 2005, 08:24 AM
Post #4


Administrator
Group Icon

Group: Admin
Posts: 10,302
Joined: 9-February 03
From: Jacksonville, FL
Member No.: 1
 United States


That's odd....but whatever works. smile.gif
Go to the top of the page
 
+Quote Post

Reply to this topicStart new topic
1 User(s) are browsing this forum (1 Guests and 0 Anonymous Users)
0 Members:

 

Lo-Fi Version Time is now: 30th August 2008 - 06:48 AM

  Page top

Webber Enhanced skin created by Im4eversmart of RuneHQ.

  Webmasters     Cool Sites     Money Network     Privacy Policy