Hi,
Am using tablemanager module.I created a table sample with 1 column.I got the following error.
user warning: Incorrect integer value: '' for column 'tid' at row 1 query: INSERT INTO tablemanager (tid, uid, name, description, header) VALUES ('', 1, 'sample', 'sample', 'a:1:{i:0;a:3:{s:4:\"data\";s:4:\"name\";s:4:\"type\";s:1:\"1\";s:8:\"required\";s:1:\"1\";}}') in D:\htdocs\Drupal-CPS\includes\database.mysql.inc on line 172.
as well as the message table has been created.But when i click on the view tables tab it displays no tables in database.Another thing for what purpose the selection box choice fieldset is ,what we have to type in that space..
can someone help me on this.

thanks,
ashwad

Comments

pobster’s picture

pobster commented
Status: Active » Closed (fixed)

Tablemanager was created for MySQL and as such doesn't really work sufficiently for other database solutions. You may have to create the first table by 'hand' to kickstart the auto incrementing tid column... In the new (unreleased as of yet) version I've removed the auto incrementing db tables and used the internal Drupal db functions instead.

BTW, the reason you see no tables is because none are created because of the error.

You can leave the selection box 'blank' ('blank' meaning you'll need to stick a space or something in there as it's stated as being required) it's for when you need a ...selection box... surprise, surprise...

Next time when you have an issue with a module, post the issue to the modules issue page rather than file it as a Drupal bug. I only found this by accident.

Pobster

ashwad’s picture

ashwad commented
Title: regarding tablemanager » hi
Status: Closed (fixed) » Active

Hi,
thank you very much.

stevenpatz’s picture

stevenpatz
he/him
commented
Title: hi » regarding tablemanager
Status: Active » Closed (fixed)