(NO BUG) uddeim SQL error: Unknown column

i am getting this error when i try to send a private message to someone.

[code:1]SQL errorDB function failed with error number 1054
Unknown column 'lastsent' in 'field list' SQL=UPDATE jos_uddeim_emn SET lastsent=1208644428 WHERE userid=62
SQL =
UPDATE jos_uddeim_emn SET lastsent=1208644428 WHERE userid=62[/code:1]

Post edited by: slabbi, at: 2008/08/13 12:07

PLEASE USE THE FORUM SEARCH!

PLEASE CHECK THE README! It explains how to upgrade uddeIM.

Post edited by: slabbi, at: 2008/07/16 20:55

slabbi was right looked in the read me and saw the tables i needed to inject into the DB of my site but for those that are still wondering here is what i injected using MySQLAdmin. even tho i dont remember upgrading and i did do a first time install i still had to do this, maybe i was drunk at the time and might not remember.

below is the code to inject, it is included in the README UDDEIM 1.1 along with other upgraded versions.

[code:1]ALTER TABLE `jos_uddeim` ADD `publicname` TEXT ;
ALTER TABLE `jos_uddeim` ADD `publicemail` TEXT ;
ALTER TABLE `jos_uddeim_emn` ADD `public` INT( 1 ) DEFAULT '0' NOT NULL ;
ALTER TABLE `jos_uddeim_emn` ADD `lastsent` INT( 11 ) DEFAULT '0' NOT NULL ;
CREATE TABLE IF NOT EXISTS `jos_uddeim_userlists` (
`id` int(11) NOT NULL auto_increment,
`userid` int(11) NOT NULL default '0',
`name` varchar(40) NOT NULL default '',
`description` text NOT NULL,
`userids` text NOT NULL,
PRIMARY KEY (`id`),
KEY `userid` (`userid`)
) TYPE=MyISAM;[/code:1]

Note: Above is for upgrading uddeIM 1.0 to 1.1 only.

Check the README when you upgrade from an earlier version of uddeIM.

ALTER TABLE `jos_uddeim` ADD `publicname` TEXT ;
Is that how am supposed to add or salve the table?


OPTIMIZE TABLE `jos1_uddeim``publicname` TEXT ;

Can a good smaritan help me with how to ALTER TABLE.

With me i have tried to click on Jos_uddeim and then Optimized of the the page took me to another page where i can edit the table. But i did not know what to do next or how to ALTER TABLE 'jos_uddeim'

Your help with how to do this will be highly appreciated.

Thanks

You have to be able to get in your mysql admin page and you have to add the code thats in the READ ME and press GO dont worry about alrering the tables the entire code does it for you.

Try this When you log in to your phpMyAdmin, then click on DATABASES then click the database you want to add the code into then click SQL and copy the code thats for your version both are below and also in the README file then when finished inderting the code press GO, that should do the rest for you.

When you upgrade 1.0 to 1.1:

[code:1]ALTER TABLE `jos_uddeim` ADD `publicname` TEXT ;
ALTER TABLE `jos_uddeim` ADD `publicemail` TEXT ;
ALTER TABLE `jos_uddeim_emn` ADD `public` INT( 1 ) DEFAULT '0' NOT NULL ;
ALTER TABLE `jos_uddeim_emn` ADD `lastsent` INT( 11 ) DEFAULT '0' NOT NULL ;
CREATE TABLE IF NOT EXISTS `jos_uddeim_userlists` (
`id` int(11) NOT NULL auto_increment,
`userid` int(11) NOT NULL default '0',
`name` varchar(40) NOT NULL default '',
`description` text NOT NULL,
`userids` text NOT NULL,
PRIMARY KEY (`id`),
KEY `userid` (`userid`)
) TYPE=MyISAM;[/code:1]

When you upgrade 0.9b to 1.1:

[code:1]ALTER TABLE `jos_uddeim` ADD `publicname` TEXT ;
ALTER TABLE `jos_uddeim` ADD `publicemail` TEXT ;
ALTER TABLE `jos_uddeim_emn` ADD `public` INT( 1 ) DEFAULT '0' NOT NULL ;
ALTER TABLE `jos_uddeim_emn` ADD `lastsent` INT( 11 ) DEFAULT '0' NOT NULL ;
CREATE TABLE IF NOT EXISTS `jos_uddeim_config` (
`varname` tinytext NOT NULL,
`value` tinytext NOT NULL,
PRIMARY KEY (`varname`(30))
) TYPE=MyISAM;
CREATE TABLE IF NOT EXISTS `jos_uddeim_userlists` (
`id` int(11) NOT NULL auto_increment,
`userid` int(11) NOT NULL default '0',
`name` varchar(40) NOT NULL default '',
`description` text NOT NULL,
`userids` text NOT NULL,
PRIMARY KEY (`id`),
KEY `userid` (`userid`)
) TYPE=MyISAM;[/code:1]

Post edited by: MrPerez, at: 2008/04/30 11:17