[Freerealty] A db question...

[Patrick Fleming]

I will place my comments here at the top. 

First, I overlooked the fact that you are running a more current MySQL
than I am. Obviously, changes to MySQL will cause differences in behavior.
Second, the errors *appear* to be related to capitalization in the
commands on the page. MySQL 4.0 may be more sensitive to capitalization of
commands than previous versions, although the online docs at mysql.com do
not indicate this is so.

PhpMyAdmin might also be case sensitive somehow.  I have attached a
modified configurator.sql file with changes to capitalization throughout
(I think I got them all). Please let me know if you are able to load this
into the database. Based on your second email I suspect that it's
myphpadmin that is creating the problem, but I don't have it installed to
test and making the files upper case is only slightly slower than typing
all lower case.

On Sun, 6 Apr 2003, Reply_To wrote:


> 
> Here are the errors I get when trying to use the configurator.sql:
> 
> Error
> 
> SQL-query :  
> 
> CREATE TABLE agents(
> id int NOT NULL AUTO_INCREMENT,
> PRIMARY KEY ( id ) ,
> agent VARCHAR( 30 ) ,
> agentpass VARCHAR( 10 ) ,
> agenturl VARCHAR( 70 ) ,
> agentemail VARCHAR( 70 ) ,
> notes TEXT,
> agentphone VARCHAR( 30 ) ,
> agentcell VARCHAR( 30 ) ,
> agentfax VARCHAR( 30 ) ,
> agenttitle VARCHAR( 30 )
> ) CREATE TABLE agent_tbl_Files(
> id_files int not null auto_increment,
> PRIMARY KEY ( id_files ) ,
> bin_data longblob not null ,
> description tinytext,
> filename VARCHAR( 50 ) ,
> filesize VARCHAR( 50 ) ,
> filetype VARCHAR( 50 ) ,
> agentnum int,
> owner int,
> thumb longblob,
> thumb_size varchar( 50 ) ,
> thumb_filetype varchar( 50 )
> )

-- 
Patrick Fleming
Webmaster, 
www.flaghometeam.com
www.rwcinc.net
www.jaysindianarts.net


-------------- next part --------------
A non-text attachment was scrubbed...
Name: configurator.sql
Type: application/octet-stream
Size: 4716 bytes
Desc: 
Url : http://lists.rwcinc.net/pipermail/freerealty/attachments/20030407/8489a0c9/configurator-0001.obj