Hi,

I added a column to my Links table for File Upload and everything works fine from the admin section and I am able to upload images perfectly! What is the tag that I have to enter in my webpage (user section) So that my users can upload images for that field using add.cgi ?

Thanks in advance,
PCMANIA

Hi,

You need to make sure you add:

ENCTYPE="multipart/form-data"

to your <FORM> tag, and then just add:

<INPUT TYPE="FILE" NAME="ColumnName">

where you want the browse button.

Cheers,

Alex
--
Gossamer Threads Inc.

Hi Alex,

Thanks for the above help! It looks good! However When I try to add a recod through admin it gives me this error:

Problems adding record: Failed to execute query: 'INSERT INTO Links_Files () VALUES ()' Reason: Table 'YellowpagesDB.Links_Files' doesn't exist


What is going on here?

Hi,

Ugh, I found the problem and there isn't yet an easy fix. Right now the only solution is to change your table prefix to links_ or l_ or anything that doesn't have Links in it.

I'm looking into this to see for better fixes.

Cheers,

Alex
--
Gossamer Threads Inc.

Hi Alex,

How am I suppose to do that???????? I tried to do this via SETUP -> SQL SERVER and I changed the prefix from Links to links and I deleted all of my data! I have a copy of the database witch is in .sql format how am I suppose to do a restore??? I tried this using Database -> Import but it didn't work! Is there anyway to do this via shell? Can you enter the exact cmmands that I have to enter?

Thanks in advance,
PCMANIA

Hi,

Your data isn't gone, if you switch back to the other prefix it will be there (just make sure you don't use the overwrite setting).

To switch prefixes you would need to:

1. Goto Database->Import/Export->Export data to file
2. Goto Setup->SQL Options and switch the prefix (but don't use overwrite).
3. Goto Database->Import/Export->Import data from file.

Cheers,

Alex
--
Gossamer Threads Inc.

Never Mind I got it! Thanks alot for your help!