Thats what I was getting until I did this:
backed up from phpmyadmin, then replaced latin1 with utf8 then reuploaded the sql and I havent had a single sql email since. www.coddepot.com is running 9.1.0.6 since this morning (Ive been running cvs on it for over a year now)
.::..::.
Server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS):
Linux/2.2.6/5.0.86/5.2.8/9.3.2
alvaOffline
Joined: May 31, 2005
Posts: 1150
Location: The Netherlands
Thats what I was getting until I did this:
backed up from phpmyadmin, then replaced latin1 with utf8 then reuploaded the sql and I havent had a single sql email since. www.coddepot.com is running 9.1.0.6 since this morning (Ive been running cvs on it for over a year now)
Is my error related to the VARBINARY thing?
On /install.php
While executing query "ALTER TABLE nuke_bbsearch_wordlist CHANGE word_text word_text VARCHAR(50) NOT NULL DEFAULT ''"
the following error occured: Duplicate entry 'oke' for key 1
@Bigern75: Lycos has changed something since their phpMyAdmin has no way anymore to check for encoding.
Server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS):
Linux/Apache/5.0.24/5/9.1 CVS
alvaOffline
Joined: May 31, 2005
Posts: 1150
Location: The Netherlands
We had the same issue on our website but we still didn't figure out why that table was "VARCHAR BINARY" or "VARBINARY"
I've fixed it by dumping all data and reinserting it and ignoring duplicate entries.
The issue i've found is that MySQL has an huge issue with BINARY data and the UNIQUE index.
Hmm, my version of MySQL considers 'officiele' and 'officiële' to be duplicates. Same with 'een' and 'één' duplicate. The first case is about a spellingmistake and the last case is about different words.
So there's an encoding issue?
I'm not sure how these tables are used, so I don't know what the consequences are of deleting entries.
Any suggestions?
Server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS):
Linux/Apache/5.0.24/5/9.1 CVS
alvaOffline
Joined: May 31, 2005
Posts: 1150
Location: The Netherlands
@alva, my error was the same as DJMazes. The flood sql errors.
Heres some other errors I was getting till I changed the language stuff. dragonflycms.org/Forum...14287.html
After changing all the latin1's to utf8's I stopped getting sql errors.
.::..::.
Server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS):
Linux/2.2.6/5.0.86/5.2.8/9.3.2
alvaOffline
Joined: May 31, 2005
Posts: 1150
Location: The Netherlands
The drastic changes for coppermine are not in the blocks yet. Actually I only know for sure about the last/thumbnails block. It's query still has 'YES' instead of 1 which resulted in 0 pictures shown.
Server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS):
Linux/Apache/5.0.24/5/9.1 CVS
alvaOffline
Joined: May 31, 2005
Posts: 1150
Location: The Netherlands
I dont know if its a bug but if you enter an id in "Skype" it shows on the profile but not on the "view topics" like other messengers do like "yim or msn"
Server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS):
Linux / Apache2.2.8 / MySQL5.0.45 / PHP5.2.6 / CVS
alvaOffline
Joined: May 31, 2005
Posts: 1150
Location: The Netherlands
Why do I still get mails about flood sql errors when i have disabled flood protection ?
f.ex:
On /Your_Account/redirect=1.html While executing query "INSERT INTO nuke_security_flood VALUES ('BùG ', '1137940424', '0')" the following error occured: Duplicate entry 'BùG' for key 1 Guest information: User id: 1 Username: webmaster Admin: No IP: 66.249.71.32 Host: crawl-66-249-71-32.googlebot.com
and just to let u know about install.
Same problem when selecting language in installer like alva, no ohter problems at this stage (9.1.0.7)..
The last test install I did for 9.1.0.7 was timezone pulldown. There was no timezones in it. Otherwise, I have it running on a local box here at my house with almost all the modules,blocks and themes I can find. And it runs great.
Specs:
AMD 1ghz .75gb ram
CMS Version 9.1.0.7
PHP Version 5.0.5-2ubuntu1.1
MySQL Version 4.0.24_Debian-10ubuntu2-log (client: 4.0.24)
Server API Apache 2.0 Handler
Apache Version Apache/2.0.54 (Ubuntu) PHP/5.0.5-2ubuntu1.1 mod_ssl/2.0.54 OpenSSL/0.9.7g
.::..::.
Server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS):
Linux/2.2.6/5.0.86/5.2.8/9.3.2
KeyholeOffline
Joined: Jun 26, 2005
Posts: 31
Location: Minneapolis