Hi I am using Drupal 5.3.
I have installed the module and I am getting this error.
Any idea what the fix might be?
Thanks in advance.

user warning: Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation '=' query: select b.module, ba.condition_type, ba.condition_value, b.delta AS bid from block_assign ba, blocks b WHERE ba.module = b.module AND ba.box_id = b.delta AND ba.module = "menu" AND ba.box_id = "134" in /home/bcspecificclaims/public_html/includes/database.mysql.inc on line 172.

Comments

dadderley’s picture

dadderley commented

Now I have a big problem. I could not turn off the module.
Now I am getting this:
Fatal error: Call to undefined function: block_assign_show() in /home/bcspecificclaims/public_html/includes/common.inc(1347) : eval()'d code on line 1
The site is borked.
What happened?

TheresaM’s picture

TheresaM commented

Fatal error: Call to undefined function block_assign_show() in /home/DrupalSC/includes/common.inc(1347) : eval()'d code on line 1

I'm getting the same error

dllh’s picture

dllh commented

Hmm, my guess is that the install didn't work b/c of the collation issue but you pasted the block_assign_show() function call into a block. If the module didn't install successfully, then the call is in fact to a function that doesn't exist. A temporary fix to unbork your site would be to edit common.inc.php (or index.php) to define an empty block_assign_show() function so that you can edit the block and remove the reference.

Re the collation issue, what version of mysql are you running?

Sorry about the late reply on this.

doc2@drupalfr.org’s picture

doc2@drupalfr.org commented

I'd like to test this module but its issues are "scary":

enabling it causes all blocks to use its functions... what happens if we manage to disable it: do the blocks downgrade to the previous version? Or does the module allows to uninstal it and reset the blocks to their previous/default settings?

What about the current critical issue? Goug, Theresa, or someone else, have you tried dllh's advise?

TheresaM’s picture

TheresaM commented

sorry it has been some time since I've been here on the site. No I tore my first site build down because I felt it was way above my head at the time I began building. I've been reading alot and trying to learn more about html , css, and php. still just very basic in my knowledge but i've been practicing and just recently attempting another site build. this time i've upgraded to the 6.x release. Not sure i'm going to accomplish a working site, but i'm sure going to give it a try. I have a little better understanding now when I come to these forums. Sorry wish I could be of more help,

summit’s picture

summit commented

Subscribing, greetings, Martijn