Gossamer Forum
(Advanced Search)
for
Home : Products : Gossamer Links : Version 1.x :

User Attach Bug

Feb 6, 2000, 9:30 PM
Lepo75
User (63 posts)
Lepo75's avatar
Feb 6, 2000, 9:30 PM
Post #1 of 6
Views: 2295
Shortcut
Quote Reply
User Attach Bug
Just setup an USER attach dir.

Trying to add an user with an image attached Linksql responds...

Code:
DBSQL (-2038653): Fatal Error: Unable to execute query: INSERT INTO Users_Attach (ID, DataID, ServerName, FileName, FileType, FileSize) VALUES (?, lepo5, "lepo5.fil", 'post2.gif', 'image/gif', 304) . Reason: Unknown column 'lepo5' in 'field list' at C:\Inetpub\wwwroot\linksql\cgi-bin\admin\admin.cgi line 65

hmmm. just got lost.

thank you in advance


lepo
Feb 6, 2000, 9:38 PM
Michael_Bray
User (378 posts)
Feb 6, 2000, 9:38 PM
Post #2 of 6
Views: 2220
Shortcut
Quote Reply
Re: User Attach Bug In reply to
Hmmm... The error seems to be NT Smile

Just kidding, I had this problem - Just make sure the Defs are right and rebuild the tables and it should fix it.

BTW - This didn't happen to me with an upload - it happened with text - so try what I said at your own risk... Wink

------------------
Michael Bray
Review your webhost or find a new one.
www.webhostarea.com
Links SQL User
------------------




Feb 7, 2000, 10:05 AM
Lepo75
User (63 posts)
Lepo75's avatar
Feb 7, 2000, 10:05 AM
Post #3 of 6
Views: 2221
Shortcut
Quote Reply
Re: User Attach Bug In reply to
found the problem...

on DBSQL.pm... in sub create_attach_table...
Code:
CREATE TABLE $table (
ID INT UNSIGNED AUTO_INCREMENT PRIMARY KEY,
DataID INT UNSIGNED NOT NULL,
ServerName CHAR(40),
FileName CHAR(40),
FileType CHAR(40),
FileSize INT UNSIGNED NOT NULL DEFAULT 0,

INDEX datandx (DataID)

DataID is INT UNSIGNED NOT NULL and cannot accept the username.

Alex. How can I fix this little problem?



thanks in advance

lepo
Feb 7, 2000, 12:52 PM
pugdog
Veteran / Moderator (6956 posts)
Feb 7, 2000, 12:52 PM
Post #4 of 6
Views: 2230
Shortcut
Quote Reply
Re: User Attach Bug In reply to
If this table is already created, you can use the "alter" command to change the type of the field.

If this table is something that is created and then deleted by this routine, then you need to change the field identifier to "text" or to a CHAR field of the right length. Because it's indexed, it has to be "not null"



------------------
POSTCARDS.COM -- Everything Postcards on the Internet www.postcards.com
LinkSQL FAQ: www.postcards.com/FAQ/LinkSQL/








Feb 8, 2000, 4:27 PM
Alex
Administrator (9387 posts)
Feb 8, 2000, 4:27 PM
Post #5 of 6
Views: 2241
Shortcut
Quote Reply
Re: User Attach Bug In reply to
Hmm, that makes things complex. I'm beginning to think the built in attachments may not have been such a good idea. You can switch the create table to a CHAR(16) (should be same as how it's defined in the Users table), but then that'll affect any new attachments created.

I've added this to my todo list.

Cheers,

Alex
Feb 9, 2000, 11:39 AM
Lepo75
User (63 posts)
Lepo75's avatar
Feb 9, 2000, 11:39 AM
Post #6 of 6
Views: 2216
Shortcut
Quote Reply
Re: User Attach Bug In reply to
Yes Alex, change table to char(14) as your instructions... it works great now, but also I had to do another little change...

in attach_file, just gefore make the INSERT I enclosed:

Code:
$data_id = $data_id ? $DBH->quote($data_id) : "''";

thank you alex and all of you guys, your support is really appreciated.

lepo