Mysidia Adoptables Support Forum

Mysidia Adoptables Support Forum (http://www.mysidiaadoptables.com/forum/index.php)

- Questions and Supports (http://www.mysidiaadoptables.com/forum/forumdisplay.php?f=18)

- - darn it (http://www.mysidiaadoptables.com/forum/showthread.php?t=1945)

Well yeah, Fadillzzz is right, your sql table is missing two columns. I have no idea why this happens, you were not using a fresh install of Mys v1.1.4, were you? I am pretty sure the new configwrite.php file does automatically create two new columns in table prefix_owned_adoptables.

This is the CREATE table query from the installation script

PHP Code:


		
			
$query = "CREATE TABLE ".$prefix."adoptables (id INT NOT NULL AUTO_INCREMENT PRIMARY KEY, type varchar(40), description varchar(300), eggimage varchar(120), whenisavail varchar(50), promocode varchar(50), freqcond varchar(50), number INT, datecond varchar(50), date varchar(20), adoptscond varchar(20), moreless varchar(20), morelessnum INT, levelgrle varchar(25), grlelevel INT, alternates varchar(10), altoutlevel INT, altchance INT, pricestatus varchar(10), pricevalue INT)";

The pricestatus field's type is varchar with length of 10
the pricevalue field's type is int

For pricestatus use latin1_general_ci
For pricevalue leave it blank

I think they're both NULL by default

EDIT: Sorry for double post

Ya that worked.

I did do a fresh install I dunno why it didn't work,