| Author |
 Topic  |
|
|
Classicmotorcycling
Development Team Leader
Australia
2085 Posts |
 Posted - 23 July 2002 : 06:04:52
|
Wesley,
I have been trying to install your mod, but the set-up keeps giving the following error:
There was an error [Microsoft][ODBC SQL Server Driver][SQL Server]There are more columns in the INSERT statement than values specified in the VALUES clause. The number of values in the VALUES clause must match the number of columns specified in the INSERT statement.
If it is "already exists" error then ignore it. If it is something else investigate it.
I can not see why it is doing this. It basically gives the same error on Access as well as SQL 2000. It looks like something I could be intrested in, but it will not work at present.
After I have run the set-up I have tried the Photo Album and it comes up, just when you go to add things to it, you can not. Do you have any idea why?
Regards,
Webmaster @ Classic Motorycling Australia
Classic Motorcycling Australia |
|
|
laser
Advanced Member
Australia
3859 Posts |
Posted - 23 July 2002 : 06:10:33
|
I haven't tried this mod, but (just in case you don't know), that error is an error caused by the INSERT command being wrong.
Proper syntax :
INSERT INTO "table_name" ("column1", "column2", ...) VALUES ("value1", "value2", ...)
Your error is that the code doesn't supply a calue for each nominated column.
HIH ...
|
 |
|
|
burthold
Junior Member
USA
426 Posts |
Posted - 24 July 2002 : 23:54:12
|
I'll check the setup file right now. I forget to check the help forum for mod setups.
Wes
|
|
|
|
burthold
Junior Member
USA
426 Posts |
Posted - 25 July 2002 : 00:05:22
|
The insert statement shouldn't stop you from uploading to the album once you go to your admin options and set them. If you have the album setup you will need to goto the admin photo setup and add users. You have to check the box next to the drop down menu to add the user you want. I have fixed the setup error I will test with all three ms-sql mysql and access tonight.
Wes
|
|
|
|
burthold
Junior Member
USA
426 Posts |
Posted - 25 July 2002 : 00:23:50
|
I did a clean install of snitz under access/ms-sql/mysql I ran the new fixed photo_album_setup.asp and it went off without a hitch. I then went to the photo album admin page and set the config and added admin as a user went to the admin album uploaded a file no problems there. Just remember that all paths relative or not are case sensitive i.e. the uploads dir or the path to the eyebatch directory. I recommend setting up a virtual directory or a directory right under your forum directory and make sure it has write permissions setup under IIS or you will not be able to upload pictures. I have uploaded new src.zip files for both components and non components version of the photo album. Let me know if you have any further problems!
Wes
|
|
|
| |
Topic |
|
Topic Locked
