By parisp on

hi all

i have finished a site setup locally on my pc and tody i have published it online.
However i have a few problems.

1. The image module seems to be unable to handle thumbnails and displays the full images instead. visit my gllery at http://www.paphosrotaract.org/rotaract_year_2004_2005_gallery to see what i mean. I have phpinfo.php in the root of my site if that will enable u to see whats wrong.

2. The autopath module seems to be generating an error every time i edit a node. i did not have this problem locally. the error is this one

user error: Duplicate entry '0' for key 1
query: INSERT INTO url_alias (src, dst) VALUES ('node/14', 'the-rotaract-club-of-paphos') in /home/paphosro/public_html/includes/database.mysql.inc on line 66.

Fatal error: Duplicate entry '0' for key 1 query: INSERT INTO watchdog (uid, type, message, severity, link, location, hostname, timestamp) VALUES (1, 'php', 'Duplicate entry '0' for key 1\nquery: INSERT INTO url_alias (src, dst) VALUES ('node/14', 'the-rotaract-club-of-paphos') in /home/paphosro/public_html/includes/database.mysql.inc on line 66.', 2, '', '/node/14/edit', '81.21.45.44', 1138572104) in /home/paphosro/public_html/includes/database.mysql.inc on line 66

any help to resolve this problems will be much apreciated

⋅ Categories: Drupal 4.6.x

Comments

parisp’s picture

parisp commented

for problem 2 i have disabled the autopath module and i still get the error.

user error: Duplicate entry '0' for key 1
query: INSERT INTO watchdog (uid, type, message, severity, link, location, hostname, timestamp) VALUES (1, 'content', '<em>image</em>: added <em>test5</em>.', 0, '<a href=\"node/121\">view</a>', '/node/add/image', '81.21.45.44', 1138574758) in /home/paphosro/public_html/includes/database.mysql.inc on line 66.

Fatal error: Duplicate entry '0' for key 1 query: INSERT INTO watchdog (uid, type, message, severity, link, location, hostname, timestamp) VALUES (1, 'php', 'Duplicate entry &#039;0&#039; for key 1\nquery: INSERT INTO watchdog (uid, type, message, severity, link, location, hostname, timestamp) VALUES (1, &#039;content&#039;, &#039;&lt;em&gt;image&lt;/em&gt;: added &lt;em&gt;test5&lt;/em&gt;.&#039;, 0, &#039;&lt;a href=\\&quot;node/121\\&quot;&gt;view&lt;/a&gt;&#039;, &#039;/node/add/image&#039;, &#039;81.21.45.44&#039;, 1138574758) in /home/paphosro/public_html/includes/database.mysql.inc on line 66.', 2, '', '/node/add/image', '81.21.45.44', 1138574758) in /home/paphosro/public_html/includes/database.mysql.inc on line 66

help anyone?????

parisp’s picture

parisp commented

fixed

had to do with the export of the database, autoincrement was not set in tables and a weird collation was used.

Sulamita’s picture

Sulamita commented

I'm having the same error, after patching 4.6.5 to 4.6.6.

aserdaten’s picture

aserdaten commented

One way to fix it is to re-export from the database making sure that "Add AUTO_INCREMENT value" is checked, if you're using phpMyAdmin.

If you don't have that original database I assume you have to manually edit the tables to make the correct values auto-incremented. I don't know what those are, though.

twohills’s picture

twohills commented

I went thru each .mysql file manually (gotta remember all the contributed modules not just core drupal) and found the ones with autoincrement, then manually set it in mySQL query browser. tedious but I don't think it was any worse than re-doing the export and import

interesting point here is that Drupal design policy is to NOT use autoincrement - modules should be using the sequence table