Mysidia Adoptables Support Forum  

Home Community Mys-Script Creative Off-Topic
Go Back   Mysidia Adoptables Support Forum > Mysidia Adoptables > Questions and Supports

Notices

Reply
 
Thread Tools Display Modes
  #21  
Old 02-23-2011, 03:50 AM
Hall of Famer's Avatar
Hall of Famer Hall of Famer is offline
Administrator, Lead Coder
 
Join Date: Dec 2008
Location: South Brunswick
Posts: 4,448
Gender: Male
Credits: 335,385
Hall of Famer is on a distinguished road
Default

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.
__________________


Mysidia Adoptables, a free and ever-improving script for aspiring adoptables/pets site.
Reply With Quote
  #22  
Old 02-23-2011, 03:52 AM
fadillzzz fadillzzz is offline
Dev Staff
 
Join Date: Jan 2010
Posts: 501
Gender: Male
Credits: 32,903
fadillzzz is an unknown quantity at this point
Default

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
Reply With Quote
  #23  
Old 02-23-2011, 03:57 AM
fadillzzz fadillzzz is offline
Dev Staff
 
Join Date: Jan 2010
Posts: 501
Gender: Male
Credits: 32,903
fadillzzz is an unknown quantity at this point
Default

For pricestatus use latin1_general_ci
For pricevalue leave it blank

I think they're both NULL by default

EDIT: Sorry for double post
Reply With Quote
  #24  
Old 02-23-2011, 04:03 AM
RoconzaArt's Avatar
RoconzaArt RoconzaArt is offline
Member
 
Join Date: Jan 2011
Location: NJ Shore (and proud of it)
Posts: 479
Gender: Female
Credits: 45,993
RoconzaArt is an unknown quantity at this point
Default

Ya that worked.

I did do a fresh install I dunno why it didn't work,
__________________
Reply With Quote
Reply


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Darn! Domain Expired. BMR777 Other Chat 12 09-13-2008 08:14 AM


All times are GMT -5. The time now is 06:33 PM.

Currently Active Users: 9839 (0 members and 9839 guests)
Threads: 4,080, Posts: 32,024, Members: 2,016
Welcome to our newest members, jolob.
BETA





What's New?

What's Hot?

What's Popular?


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
vBCommerce I v2.0.0 Gold ©2010, PixelFX Studios
vBCredits I v2.0.0 Gold ©2010, PixelFX Studios
Emoticons by darkmoon3636