imfdb.org  

Go Back   imfdb.org > The Forum > imfdb

Reply
 
Thread Tools Display Modes
  #1  
Old 09-04-2014, 02:57 PM
Swordfish941's Avatar
Swordfish941 Swordfish941 is offline
Senior Member
 
Join Date: Oct 2009
Location: Fishers, Indiana
Posts: 3,228
Default Can't Post Pages

I recently tried to post a page for the 2014 Lupin movie, but I kept getting this:

A database query syntax error has occurred. This may indicate a bug in the software. The last attempted database query was:

(SQL query hidden)

from within function "LinkHolderArray::replaceInternal". Database returned error "1271: Illegal mix of collations for operation ' IN ' (192.168.130.4)".

Can somebody explain to be what is going on? It was working for me fine two months ago.
__________________
Can we start with part where Jayne gets knocked out by 90-pound girl? Hoban "Wash" Washburne (Alan Tudyk), Serenity

You're every bit the detective that your followers on internet believe - Brainiac, Superman The Animated Series
Reply With Quote
  #2  
Old 09-04-2014, 04:22 PM
commando552 commando552 is offline
IMFDB Admin
 
Join Date: Jan 2012
Location: England
Posts: 527
Default

I just uploaded an image so it is working or me. Have you tried changing the file name? There are certain characters that cant be in a file name, but sometimes even with a name that should be OK, the database will not like it for some reason. If you change the name slightly, even just throwing in a "1" at the end, it should then work.
Reply With Quote
  #3  
Old 09-04-2014, 05:25 PM
Swordfish941's Avatar
Swordfish941 Swordfish941 is offline
Senior Member
 
Join Date: Oct 2009
Location: Fishers, Indiana
Posts: 3,228
Default

Quote:
Originally Posted by commando552 View Post
I just uploaded an image so it is working or me. Have you tried changing the file name? There are certain characters that cant be in a file name, but sometimes even with a name that should be OK, the database will not like it for some reason. If you change the name slightly, even just throwing in a "1" at the end, it should then work.
This was for a page, rather than an image.

Still, I'll take your advice.
__________________
Can we start with part where Jayne gets knocked out by 90-pound girl? Hoban "Wash" Washburne (Alan Tudyk), Serenity

You're every bit the detective that your followers on internet believe - Brainiac, Superman The Animated Series
Reply With Quote
  #4  
Old 09-04-2014, 10:09 PM
commando552 commando552 is offline
IMFDB Admin
 
Join Date: Jan 2012
Location: England
Posts: 527
Default

Quote:
Originally Posted by Swordfish941 View Post
This was for a page, rather than an image.

Still, I'll take your advice.
Ah my bad, misread it. The problem you described sounded like the image one which people quite often run into so I assumed that was where you were getting into problems. Page creation seems to be working currently, have you managed to get it to work now or are you still getting the error? From Googling it one of the possible causes of this is an odd character in the page title, what was the exact name that wasn't working?
Reply With Quote
  #5  
Old 09-04-2014, 11:02 PM
Swordfish941's Avatar
Swordfish941 Swordfish941 is offline
Senior Member
 
Join Date: Oct 2009
Location: Fishers, Indiana
Posts: 3,228
Default

Quote:
Originally Posted by commando552 View Post
Ah my bad, misread it. The problem you described sounded like the image one which people quite often run into so I assumed that was where you were getting into problems. Page creation seems to be working currently, have you managed to get it to work now or are you still getting the error? From Googling it one of the possible causes of this is an odd character in the page title, what was the exact name that wasn't working?
I tried posting it again, and it still got the same error.
__________________
Can we start with part where Jayne gets knocked out by 90-pound girl? Hoban "Wash" Washburne (Alan Tudyk), Serenity

You're every bit the detective that your followers on internet believe - Brainiac, Superman The Animated Series
Reply With Quote
  #6  
Old 09-05-2014, 01:13 AM
funkychinaman's Avatar
funkychinaman funkychinaman is offline
IMFDB & Forum Admin
 
Join Date: Aug 2010
Location: Bucks County, PA
Posts: 2,581
Default

Quote:
Originally Posted by Swordfish941 View Post
I tried posting it again, and it still got the same error.
I did get a weird error in the delete log, but I was able to create the page.

http://www.imfdb.org/wiki/Lupin_III
__________________
"Me fail English? That's unpossible!"
Reply With Quote
  #7  
Old 09-05-2014, 02:29 AM
Swordfish941's Avatar
Swordfish941 Swordfish941 is offline
Senior Member
 
Join Date: Oct 2009
Location: Fishers, Indiana
Posts: 3,228
Default

Quote:
Originally Posted by funkychinaman View Post
I did get a weird error in the delete log, but I was able to create the page.

http://www.imfdb.org/wiki/Lupin_III
Thank you. I'll now fill it out with the stuff.
__________________
Can we start with part where Jayne gets knocked out by 90-pound girl? Hoban "Wash" Washburne (Alan Tudyk), Serenity

You're every bit the detective that your followers on internet believe - Brainiac, Superman The Animated Series
Reply With Quote
  #8  
Old 09-05-2014, 02:32 AM
Swordfish941's Avatar
Swordfish941 Swordfish941 is offline
Senior Member
 
Join Date: Oct 2009
Location: Fishers, Indiana
Posts: 3,228
Default

DAMNIT I TRIED POSTING MY STUFF ON THE PAGE, AND I GOT THE SAME BULLSHIT ERROR!

Maybe it's because of the "1271: Illegal mix of collations for operation ' IN ' (192.168.130.4)" bullcrap.
__________________
Can we start with part where Jayne gets knocked out by 90-pound girl? Hoban "Wash" Washburne (Alan Tudyk), Serenity

You're every bit the detective that your followers on internet believe - Brainiac, Superman The Animated Series
Reply With Quote
  #9  
Old 09-05-2014, 05:12 AM
funkychinaman's Avatar
funkychinaman funkychinaman is offline
IMFDB & Forum Admin
 
Join Date: Aug 2010
Location: Bucks County, PA
Posts: 2,581
Default

Quote:
Originally Posted by Swordfish941 View Post
DAMNIT I TRIED POSTING MY STUFF ON THE PAGE, AND I GOT THE SAME BULLSHIT ERROR!

Maybe it's because of the "1271: Illegal mix of collations for operation ' IN ' (192.168.130.4)" bullcrap.
I think that's a SQL error. It looks like Bunni might be working on it now.
__________________
"Me fail English? That's unpossible!"
Reply With Quote
  #10  
Old 09-07-2014, 04:26 AM
Swordfish941's Avatar
Swordfish941 Swordfish941 is offline
Senior Member
 
Join Date: Oct 2009
Location: Fishers, Indiana
Posts: 3,228
Default

Quote:
Originally Posted by funkychinaman View Post
I think that's a SQL error. It looks like Bunni might be working on it now.
The error is still happening.
__________________
Can we start with part where Jayne gets knocked out by 90-pound girl? Hoban "Wash" Washburne (Alan Tudyk), Serenity

You're every bit the detective that your followers on internet believe - Brainiac, Superman The Animated Series
Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT. The time now is 01:56 PM.


Powered by vBulletin® Version 3.8.0
Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.