Database Errors

[sven]

Hello,

I´m getting database errors if i try to update a monster

Database error in vBulletin 4.0.7:

Invalid SQL:
UPDATE dbtech_forumon_startermonster SET
title = 'Dragon',
parts = 'a:5:{s:8:\"arm_left\";s:26:\"dragon/arm_left/dragon.png\";s:9:\"arm_right\";s:27:\"dragon/arm_right/double.png\";s:4:\"head\";s:22:\"dragon/head/dragon.png\";s:8:\"leg_left\";s:26:\"dragon/leg_left/double.png\";s:9:\"leg_right\";s:27:\"dragon/leg_right/double.png\";}',
colors = 'a:6:{s:8:\"arm_left\";s:7:\"#66B1A9\";s:9:\"arm_right\";s:7:\"#5A88D7\";s:4:\"head\";s:7:\"#5429F1\";s:8:\"leg_left\";s:9:\"#551010F3\";s:9:\"leg_right\";s:7:\"#B2CA8C\";s:5:\"torso\";s:7:\"#7D31D6\";}',
dateline = 1288803544
WHERE startermonsterid = 1;

MySQL Error : Unknown column 'parts' in 'field list'
Error Number : 1054
Request Date : Wednesday, November 3rd 2010 @ 12:59:04 PM
Error Date : Wednesday, November 3rd 2010 @ 12:59:04 PM
Script : http://xxxxxxxx.com/forumonadmin.php?do=startermonster
Referrer : http://xxxxxxxx.com/forumonadmin.php?do=startermonster&action=modify&startermonsterid=1
IP Address : xxx.xxxx.xxx.7
Username : xxxxxxxxx
Classname : vB_Database
MySQL Version : 5.0.90

If I try to delete this monster i get

Could not find dbtech_forumon_startermonster with startermonsterid = 1.

This monster exsists and is shown on "Manage Starter Monsters"

Also got these errors:

Database error in vBulletin 4.0.7:

Invalid SQL:

DELETE FROM dbtech_forumon_monsterlist
WHERE enemyid =;

MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 2
Error Number : 1064
Request Date : Wednesday, November 3rd 2010 @ 10:30:23 AM
Error Date : Wednesday, November 3rd 2010 @ 10:30:23 AM
Script : http://xxxxxxxx.com/forumonadmin.php?do=startermonster
Referrer : http://xxxxxxxx.com/forumonadmin.php?do=startermonster&action=delete&startermonsterid=1
IP Address : xxx.xxx.xxx.7
Username : xxxxxxxx
Classname : vB_Database
MySQL Version : 5.0.90


Warning: unlink([path]/dbtech/forumon/images/startermonsters/1.png) [function.unlink]: No such file or directory in [path]/dbtech/forumon/includes/class_dm_startermonster.php on line 237

Can you give me a hint please how to fix this

Many thanks.

sven

 

[Fillip H.]

http://www.dragonbyte-tech.com/thre...-Starter-Monster?p=10767&viewfull=1#post10767

 

[sven]

Many thanks Fillip H. - this fixed the probs