This is exactly the same issue I'm having. I'm running vbulletin 3.6.7

Will there be a fix for the problems that crop up when you try to edit a post with an item already in it?

I know you have it listed as a Known Issue, but just wondering if this will be fixed.

Database error in vBulletin 3.5.3:

Invalid SQL:

### INSERT QUERY GENERATED BY fetch_query_sql() ###
INSERT INTO xzxplugin
(`active`, `executionorder`, `title`, `hookname`, `phpcode`, `product`)
VALUES
('1', '5', 'gIS: Itemstats - AdminCP', 'admin_global', 'if (!defined(\'ITEMSTATS_LOADED\') && file_exists(DIR . \'/includes/functions_gitemstats.php\'))\r\n{\r\n require_once(DIR . \'/includes/functions_gitemstats.php\');\r\n}', 'gItemStats');

MySQL Error : Unknown column 'executionorder' in 'field list'
Error Number : 1054
Date : Tuesday, July 17th 2007 @ 12:37:47 PM
Script : http://forum.xazax.com/admincp/plugin.php
Referrer : http://forum.xazax.com/admincp/plugin.php?do=productadd
IP Address : 80.127.223.56
Username : XXXXXXXXX
Classname : vb_database


Don't know what i am doing wrong :(

You are trying to install a mod for vBulletin version 3.6 on vBulletin 3.5.

Try this addon, it will allow you to install 3.6 mods on 3.5.

ok script runs now. but now i see this on top of my webpage

Failed to update item: Cape of the Brotherhood (Table 'xzxvbull.xzxgitemstats' doesn't exist)
Failed to update item: Cape of the Brotherhood (Table 'xzxvbull.xzxgitemstats' doesn't exist)
Failed to update item: Cape of the Brotherhood (Table 'xzxvbull.xzxgitemstats' doesn't exist)
Failed to update item: Cape of the Brotherhood (Table 'xzxvbull.xzxgitemstats' doesn't exist)

Itemstats, code I did not write which is included in the mod, handles the creation of a cache table in the database. For some reason it is not creating the table, you will have to create it manually, the structure is found in itemstats/includes/itemcache.php

I realy have no idea how hahahha

Gryphon great job with this one...

I have a minor update that uses the WOWHEADS feed, let me know if its worth doing?

Its another bbcode that uses less resources...

Keep the ball rolling...:up:

I can't seem to get mine to either install correctly or work with vBadvanced. Anyone getting the same problem or know a fix?

anyone know how to fix the enchants as i can't seem to get this mod to show any of the enchants using the [item] tags