Duplication in database

[LittleGrizzly]

Hello,

I use your Downloadcomponent on my website for wallpapers (Section ID 1). I have two categories, 1024x768 (Category ID 2) and 1280x1024 (Category ID 1)
The 1024x768-Categorie I´ve filled up manual, it took days to fill all 87 wallpapers.
In the 1280x1024-Categorie I tried to copy the content via database. I changed the File-ID with an increasing number, changed the category ID from 2 to 1 and changed the filenames and the folder (the structure of both cats is very similar).

My database file from the manually insert of files looks like this:
http://testforum.grizzly-adams.de/datab ... insert.txt

My changed database code for inserting the files into category 1280x1024 looks like this:
http://testforum.grizzly-adams.de/database_changes.txt

When I try to add my changed database-entries for filling up the other categorie I get following error in PHPMyadmin:

Code: Select all

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '89, 1, 1, 0, 0, 'Ben1', 'ben1', '1280x1024/Ben1_1280.zip', 601677, '', '', '', '' at line 1
(89, 1, 1, 0, 0, 'Ben1', 'ben1', '1280x1024/Ben1_1280.zip', 601677, '', '', '', '', '', '', '', '', '', 'Ben1_1024.jpg', '', '', '', '', 0, '2010-07-11 10:36:23', '2010-07-11 10:36:23', '0000-00-00 00:00:00', 1, 0, 1, 1, 66, '2010-07-21 11:18:26', 1, 0, -1, 0, NULL, '', ''),
(90, 1, 1, 0, 0, 'Jan-Axel Alavaara', 'jan-axel-alavaara', '1280x1024/alavaara_grey_1280.zip', 794015, '', '', '', '', '', '', '', '', 'alavaara_grey_1024.jpg', '', '', '', '', '', 0, '2010-07-11 11:08:44', '2010-07-11 11:08:44', '0000-00-00 00:00:00', 1, 0, 1, 1, 0, '0000-00-00 00:00:00', 2, 0, -1, 0, NULL, '', ''),
(91, 1, 1, 0, 0, 'Michael Bartosch', 'michael-bartosch', '1280x1024/bartosch1280.zip', 790651, '', '', '', '', '', '', '', '', 'bartosch1024.jpg', '', '', '', '', '', 0, '2010-07-21 10:40:59', '2010-07-21 10:40:59', '0000-00-00 00:00:00', 0, 0, 1, 1, 0, '0000-00-00 00:00:00', 3, 0, -1, 0, NULL, '', ''),
(92, 1, 1, 0, 0, 'Ben grau', 'ben-grau', '1280x1024/ben_grey_1280.zip', 809613, '', '', '', '', '[...]

Are there more entries that have to be changed? Filesize and so isn´t important or are they? I thought I only have to change the category where I want to insert the new files and the folder/name that contains the new files.

Can you understand the error and can you tell me what more I have to change? Copying files from one into another category doesn´t work on another way and I really don´t want to insert 88 Files manually again

Thanks,
Steffi

[Jan]

Hi, the database says, there is some syntax error, it means, some format is wrong, maybe "," is missing somewhere, maybe ";" is missing, maybe you load more or less values than columns, etc.

Jan

[LittleGrizzly]

Okay, I´m not finding the problem, so I will insert everything manually. Think, I´ll survive it.
But now there´s the next problem: In IE7 all file pictures are messed up. This page: http://testforum.grizzly-adams.de/index ... 2-1024x768 looks in IE7 like this:
Not very nice How can I repair this?

And I would like to change the picture and the link, the picture (all at same size) should be on the LEFT the Link to the file should be on the RIGHT. But I´m not sure what to change and where it has to be changed...

Thanks in advance,
Stephanie

[Jan]

Hi, try to rename the images so it can be displayed the same way like here:

https://www.phoca.cz/download/category/2 ... -templates

See:
https://www.phoca.cz/documents/17-phoca- ... -file-name

Jan

[LittleGrizzly]

Wow, that´s amazing, now it works with the images.

Thanks again,
Stephanie

[Jan]

Ok