LMan, search is broken...

Post bug reports and suggestions for improving Remix64.com or AmigaRemix here. For other sites, contact the respective site maintainers directly.
Post Reply
User avatar
merman
Forum Fish
Forum Fish
Posts: 1935
Joined: 24/01/2003 - 10:42
Location: Skegness, UK
Contact:

LMan, search is broken...

Post by merman »

Had a few problems with the site today. First of all I couldn't use the "New posts since your last visit" option. And then I was trying to search and got a very similar error message.
--Anyone want to remix my SIDs?--
merman1974 on Twitter, Steam and Xbox Live
User avatar
LMan
R64 Founder
R64 Founder
Posts: 3660
Joined: 21/11/2002 - 12:44
Contact:

Post by LMan »

Hi merman, thanks for the info. Could you please pm or eMail the error message to me if you encounter it again?

Thanks. :)
User avatar
Romeo Knight
Supreme Strumming Daddy
Supreme Strumming Daddy
Posts: 1390
Joined: 20/05/2004 - 20:52
Location: Duesseldorf, Germany
Contact:

Post by Romeo Knight »

Hi Markus,
still busy? Hope everything's running smoothly.
I had a bad hangover after the evening with Slaygon. :)

Back to topic:
Another strange thing is this: When I click on X-Klang on the charts for the Arranger Info I get this:
ATARI - Remix64 Member Profile
No votes cast.Real Name
Wolfgang Deibler
Nation
German
Year of birth
1976
Contact atari
wsdoomwebde
RKO Arranger Name
X-Klang
RKO Homepage
http://www.x-klang.de
AFAIK this is plain wrong. :)
And X-klang never had an Atari!
Image
User avatar
LMan
R64 Founder
R64 Founder
Posts: 3660
Joined: 21/11/2002 - 12:44
Contact:

Post by LMan »

Fixed.

Every now and then the occasional new member selects the option "Yes, I have released remixes at remix.kwed.org!", obviously without knowing what it's supposed to mean.

So when they're required to select which arranger they are, they select anyone. Which will link up his account with the arranger. So the arranger gets notified with the password... X-Klang had already informed me about it but I didn't get around to do it earlier. :)

On the other hand, every few weeks I clean out "unclean" sign-ups from the member database - those false arrangers are among them. :)

Anyway thanks for notifying, hope you had a great time with Slagge & Lisa! :D

- Markus
User avatar
merman
Forum Fish
Forum Fish
Posts: 1935
Joined: 24/01/2003 - 10:42
Location: Skegness, UK
Contact:

Post by merman »

This is what I just got from trying to use the "View new posts since your last visit" link:

Code: Select all

General Error 
  
Could not insert search results

DEBUG MODE

SQL Error : 1062 Duplicate entry '591940590' for key 1

INSERT INTO board_search_results (search_id, session_id, search_time, search_array) VALUES(591940590, 'd9e992ec494072ae7fb090f83e5420af', 1154684217, 'a:7:{s:14:"search_results";s:52:"2522, 3367, 3864, 3880, 3892, 3895, 3899, 3900, 3901";s:17:"total_match_count";i:9;s:12:"split_search";N;s:7:"sort_by";i:0;s:8:"sort_dir";s:4:"DESC";s:12:"show_results";s:6:"topics";s:12:"return_chars";i:200;}')

Line : 706
File : search.php 
 
--Anyone want to remix my SIDs?--
merman1974 on Twitter, Steam and Xbox Live
User avatar
LMan
R64 Founder
R64 Founder
Posts: 3660
Joined: 21/11/2002 - 12:44
Contact:

Post by LMan »

Hi Andrew,

thanks. I've run a few DB repair and optimiser commands, that might help. Please let me know if it doesn't. :)

- Markus
User avatar
Vosla
General Pain In The Forum's Ass
General Pain In The Forum's Ass
Posts: 3614
Joined: 02/12/2002 - 0:12
Location: On the same little planet as you. Be VERY afraid!
Contact:

Post by Vosla »

I get a lot of these DEBUG MODE errors but trying a second or third time usually helps (with frequently browsercrashes but I guess that's my fault with misconfiguring the browser).
All is lost.
User avatar
merman
Forum Fish
Forum Fish
Posts: 1935
Joined: 24/01/2003 - 10:42
Location: Skegness, UK
Contact:

Post by merman »

Just got debug mode again when I searched for new posts :(
--Anyone want to remix my SIDs?--
merman1974 on Twitter, Steam and Xbox Live
User avatar
merman
Forum Fish
Forum Fish
Posts: 1935
Joined: 24/01/2003 - 10:42
Location: Skegness, UK
Contact:

Post by merman »

And the error is back again...
--Anyone want to remix my SIDs?--
merman1974 on Twitter, Steam and Xbox Live
Chris Abbott
Forum God
Forum God
Posts: 5307
Joined: 22/11/2002 - 12:21
Location: Dubai. No, not really.
Contact:

Post by Chris Abbott »

I get it too, but hey, it goes away the second time...

Chris
Won't somebody PLEASE think of the children?
Post Reply