1
Hi, firstly if anyone knows a good alternative to this module, please let me know.
Secondly, my problem:
When trying to update a partner in Smartpartner (v2.0) on Xoops2.3.2(b), I get the following error report:
Quote:
An error occured. The partner was not updated.
>snip<
Error number: 1054
Error message: Unknown column 'datesub' in 'field list'
I wonder if this is because when I try to update the module (after upgrading to v2.0 from v1.02) I get the following report:
Quote:
Updating database...
Database migrate to version 3
Error adding field email_priv
Error adding field phone_priv
Error adding field adress_priv
Database migrate to version 4
Error adding field last_update
Error adding field showsummary
_SDU_MSG_DROPFIELD_ERR (Can't DROP 'categoryid'; check that column/key exists)
At the bottom of the admin page on which the above mentioned report is displayed, I get the following debug error reports (table name replaced with xxxxxx for safety's sake):
Quote:
SELECT metavalue FROM v2_smartpartner_meta WHERE metakey='version'
Error number: 1146
Error message: Table 'xxxxxx.v2_smartpartner_meta' doesn't exist
ALTER TABLE `v2_smartpartner_partner` ADD `email_priv` tinyint(1) NOT NULL default '0'
Error number: 1060
Error message: Duplicate column name 'email_priv'
SELECT id, categoryid from v2_smartpartner_partner
Error number: 1054
Error message: Unknown column 'categoryid' in 'field list'
ALTER TABLE `v2_smartpartner_partner` ADD `last_update` int(11) NOT NULL default '0'
Error number: 1060
Error message: Duplicate column name 'last_update'
ALTER TABLE v2_smartpartner_partner DROP categoryid
Error number: 1091
Error message: Can't DROP 'categoryid'; check that column/key exists
SELECT metavalue FROM v2_smartpartner_meta WHERE metakey='version'
Error number: 1146
Error message: Table 'xxxxxx.v2_smartpartner_meta' doesn't exist
INSERT INTO v2_smartpartner_meta (metakey, metavalue) VALUES ('version', '4')
Error number: 1146
Error message: Table 'xxxxxx.v2_smartpartner_meta' doesn't exist
Does anyone know why I can't update/add partners, and how I might fix this?
(Like I said, if there's an alternative module, please let me know. SmartFactory have stated that they doubt new versions of their modules will continue to work as XOOPS progresses, and so I need to think about dropping the smartfactory modules I use as time goes on.)
Never let a man who does not believe something can be done, talk to a man that is doing it.
