Skip to Content Skip to Menu

UddeIM 1.6 SQL error number 1054

  • DK6IR
  • DK6IR
  • OFFLINE
  • Posts: 4
  • Thanks: 0
  • Karma: 0
15 years 9 months ago #87426 by DK6IR
UddeIM 1.6 SQL error number 1054 was created by DK6IR
First of all I am very happy to see the new release of this fantstic component. Great job! :)
Now Iam able creating contact lists which can be used by all users... a very useful tool for me!
Unfourtunately I (the admin) get an error message when I try to create such a restricted or global contact list:

SQL error when attempting to save a listDB function failed with error number 1054
Unknown column 'global' in 'field list' SQL=INSERT INTO jos_uddeim_userlists (userid, name, description, userids, global) VALUES (62, 'IRDX_MailingList', 'This list contains all registered IR-DX group members at www.irdx.org .', '0', 2)
SQL =
INSERT INTO jos_uddeim_userlists (userid, name, description, userids, global) VALUES (62, 'IRDX_MailingList', 'This list contains all registered IR-DX group members at www.irdx.org .', '0', 2)

What is the problem? can you give me an answer for dummies?

Best regards, Bert.

Please Log in or Create an account to join the conversation.

  • DK6IR
  • DK6IR
  • OFFLINE
  • Posts: 4
  • Thanks: 0
  • Karma: 0
15 years 9 months ago #87428 by DK6IR
Replied by DK6IR on topic Re:UddeIM 1.6 SQL error number 1054
I solved it by myself becuase I was reading the instruction carefully :blush:


ALTER TABLE `jos_uddeim_userlists` ADD `global` INT( 1 ) NOT NULL DEFAULT '0';
ALTER TABLE `jos_uddeim_userlists` ADD INDEX ( `global` ) ;

Please Log in or Create an account to join the conversation.

  • slabbi
  • slabbi
  • OFFLINE
  • Posts: 3709
  • Thanks: 250
  • Karma: 153
15 years 9 months ago #87448 by slabbi
Replied by slabbi on topic Re:UddeIM 1.6 SQL error number 1054
*g*

uddeIM & uddePF Development
CB Language Workgroup
CB 3rd Party Developer

Please Log in or Create an account to join the conversation.

Moderators: beatnantslabbikrileon
Powered by Kunena Forum