Welcome to Geeklog, Anonymous Tuesday, January 31 2023 @ 09:50 pm EST

Geeklog Forums

problems on mirror


Status: offline

starenka

Forum User
Newbie
Registered: 02/26/06
Posts: 9
hi i tried to get my geeklog on localhost

i used export from phpmyadmin, i'm using utf_genral_ci on both mysql servers
but when trying to run the site on localhost i got

An SQL error has occurred. Please see error.log for details.

log:
03/17/06 16:44:14 - 1271: Illegal mix of collations for operation ' IN '. SQL in question: SELECT sid FROM gl_stories WHERE draft_flag = 0 AND date 0 ORDER BY date DESC LIMIT 10

where's my problem? thx
 Quote

Status: offline

Dirk

Site Admin
Admin
Registered: 01/12/02
Posts: 13073
Location:Stuttgart, Germany
Our HTML filter seems to have eaten part of that SQL request, so can't say what's wrong with it. Post it again, using the forum's [ CODE ] tags.

A wild guess: Are you running the same MySQL versions on both servers?

bye, Dirk
 Quote

All times are EST. The time is now 09:50 pm.

  • Normal Topic
  • Sticky Topic
  • Locked Topic
  • New Post
  • Sticky Topic W/ New Post
  • Locked Topic W/ New Post
  •  View Anonymous Posts
  •  Able to post
  •  Filtered HTML Allowed
  •  Censored Content