Latest UI - Placing item's bug

[Jacob]

I have no clue why it's doing that, if you could help me that'd be great thanks!

 

[Meap]

Run this SQL

ALTER TABLE `items`
ADD COLUMN `placedBy`  int(10) NULL DEFAULT 0 AFTER `group_data`;

 

[Jacob]

Run this SQL

ALTER TABLE `items`
ADD COLUMN `placedBy`  int(10) NULL DEFAULT 0 AFTER `group_data`;

Got this error,

[Err] 1054 - Unknown column 'group_data' in 'items'
[Err] ALTER TABLE `items`
ADD COLUMN `placedBy`  int(10) NULL DEFAULT 0 AFTER `group_data`;

 

[Meap]

Try running that, I had the same issue with a hotel I work for

CREATE TABLE IF NOT EXISTS `items` (
  `item_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `base_id` smallint(5) unsigned DEFAULT NULL,
  `rareid` int(11) NOT NULL DEFAULT '0',
  `group_data` varchar(200) NOT NULL DEFAULT '',
  `placedBy` int(10) NOT NULL DEFAULT '0',
  PRIMARY KEY (`item_id`),
  UNIQUE KEY `id_UNIQUE` (`item_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=48 ;

 

[Hindi]

Got this error,

[Err] 1054 - Unknown column 'group_data' in 'items'
[Err] ALTER TABLE `items`
ADD COLUMN `placedBy`  int(10) NULL DEFAULT 0 AFTER `group_data`;

Add group_data column in items table

 

[Jacob]

Try running that, I had the same issue with a hotel I work for

CREATE TABLE IF NOT EXISTS `items` (
  `item_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `base_id` smallint(5) unsigned DEFAULT NULL,
  `rareid` int(11) NOT NULL DEFAULT '0',
  `group_data` varchar(200) NOT NULL DEFAULT '',
  `placedBy` int(10) NOT NULL DEFAULT '0',
  PRIMARY KEY (`item_id`),
  UNIQUE KEY `id_UNIQUE` (`item_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=48 ;

Thanks for sharing that, the query worked but.. same problem

Edit:

Getting this in Emu

 

[Hindi]

Thanks for sharing that, the query worked but.. same problem

Edit:

Getting this in Emu

You need to update headers. Some aren't working.

 

[Jacob]

You need to update headers. Some aren't working.

Sorry my bad, I'm new to the Latest UI - could you possibly help me through skype? I don't understand what you mean by update headers? Thanks!

 

[Jacob]

Still looking to get this fixed!


UPDATE:

I've found a fix, the problem was to do with IIS - I have fixed it by going to XAMPP..

 

[Jacob]

I removed back to IIS as it's more secure and I get the same problem, but works perfectly with XAMPP, anyone got an answer or clue?

 

[Evilsmoothie]

Well, you can start by posting the error logs. It's not a header issue, and I have a feeling just turning mysql strict mode off will solve it aswell.