For some reason I have a problem with links. after login on my site here I click profile and it puts in ?template=/ then the page i should have been directed to and last but not least errors not being found in error log. [03-Jul-2010 15:33:25] WordPress database error Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '=' for query SELECT wp_redirection_items.*,wp_redirection_groups.tracking,wp_redirection_modules.id AS module_id FROM wp_redirection_items INNER JOIN wp_redirection_groups ON wp_redirection_groups.id=wp_redirection_items.group_id AND wp_redirection_groups.status='enabled' INNER JOIN wp_redirection_modules ON wp_redirection_modules.id=wp_redirection_groups.module_id AND wp_redirection_modules.type='wp' WHERE (wp_redirection_items.regex=1 OR wp_redirection_items.url='/f2p-mmorpg-trend-hitting-it%e9%88%a5%e6%aa%9a-stride/' OR wp_redirection_items.url='/f2p-mmorpg-trend-hitting-it鈥檚-stride/') ORDER BY wp_redirection_groups.position,wp_redirection_items.position made by require, require_once, require_once, require_once, do_action, call_user_func_array, WordPress_Module->init, Red_Item->get_for_url [03-Jul-2010 15:33:25] WordPress database error Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '=' for query SELECT wp_redirection_items.*,wp_redirection_groups.tracking,wp_redirection_modules.id AS module_id FROM wp_redirection_items INNER JOIN wp_redirection_groups ON wp_redirection_groups.id=wp_redirection_items.group_id AND wp_redirection_groups.status='enabled' INNER JOIN wp_redirection_modules ON wp_redirection_modules.id=wp_redirection_groups.module_id AND wp_redirection_modules.type='wp' WHERE (wp_redirection_items.regex=1 OR wp_redirection_items.url='/f2p-mmorpg-trend-hitting-it%e9%88%a5%e6%aa%9a-stride/' OR wp_redirection_items.url='/f2p-mmorpg-trend-hitting-it鈥檚-stride/') ORDER BY wp_redirection_groups.position,wp_redirection_items.position made by require, require_once, require_once, require_once, do_action, call_user_func_array, WordPress_Module->init, Red_Item->get_for_url [03-Jul-2010 15:33:25] WordPress database error Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '=' for query SELECT wp_redirection_items.*,wp_redirection_groups.tracking,wp_redirection_modules.id AS module_id FROM wp_redirection_items INNER JOIN wp_redirection_groups ON wp_redirection_groups.id=wp_redirection_items.group_id AND wp_redirection_groups.status='enabled' INNER JOIN wp_redirection_modules ON wp_redirection_modules.id=wp_redirection_groups.module_id AND wp_redirection_modules.type='404' WHERE (wp_redirection_items.regex=1 OR wp_redirection_items.url='/f2p-mmorpg-trend-hitting-it%e9%88%a5%e6%aa%9a-stride/' OR wp_redirection_items.url='/f2p-mmorpg-trend-hitting-it鈥檚-stride/') ORDER BY wp_redirection_groups.position,wp_redirection_items.position made by require, require_once, do_action, call_user_func_array, Error404_Module->template_redirect, Red_Item->get_for_url [03-Jul-2010 20:26:02] PHP Warning: include(/home/gamescip/public_html/wp-content/plugins/wp-e-commerce/themes/marketplace/cart_widget.php) [<a href='function.include'>function.include</a>]: failed to open stream: No such file or directory in /home/gamescip/public_html/wp-content/plugins/wp-e-commerce/widgets/shopping_cart_widget.php on line 54 [03-Jul-2010 20:26:02] PHP Warning: include() [<a href='function.include'>function.include</a>]: Failed opening '/home/gamescip/public_html/wp-content/plugins/wp-e-commerce/themes/marketplace/cart_widget.php' for inclusion (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/gamescip/public_html/wp-content/plugins/wp-e-commerce/widgets/shopping_cart_widget.php on line 54 [03-Jul-2010 20:26:03] PHP Warning: include(/home/gamescip/public_html/wp-content/plugins/wp-e-commerce/themes/marketplace/cart_widget.php) [<a href='function.include'>function.include</a>]: failed to open stream: No such file or directory in /home/gamescip/public_html/wp-content/plugins/wp-e-commerce/widgets/shopping_cart_widget.php on line 54 [03-Jul-2010 20:26:03] PHP Warning: include() [<a href='function.include'>function.include</a>]: Failed opening '/home/gamescip/public_html/wp-content/plugins/wp-e-commerce/themes/marketplace/cart_widget.php' for inclusion (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/gamescip/public_html/wp-content/plugins/wp-e-commerce/widgets/shopping_cart_widget.php on line 54 [05-Jul-2010 00:23:59] PHP Warning: imagepng() [<a href='function.imagepng'>function.imagepng</a>]: Unable to open '/wpsc/cache/product_img__48x48.gif' for writing: No such file or directory in /home/gamescip/public_html/wp-content/plugins/wp-e-commerce/wpsc-includes/misc.functions.php on line 620 [05-Jul-2010 00:24:07] PHP Warning: imagepng() [<a href='function.imagepng'>function.imagepng</a>]: Unable to open '/wpsc/cache/product_img__48x48.gif' for writing: No such file or directory in /home/gamescip/public_html/wp-content/plugins/wp-e-commerce/wpsc-includes/misc.functions.php on line 620 [05-Jul-2010 00:24:13] PHP Warning: imagepng() [<a href='function.imagepng'>function.imagepng</a>]: Unable to open '/wpsc/cache/product_img__48x48.gif' for writing: No such file or directory in /home/gamescip/public_html/wp-content/plugins/wp-e-commerce/wpsc-includes/misc.functions.php on line 620 [05-Jul-2010 01:10:21] WordPress database error Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '=' for query SELECT wp_redirection_items.*,wp_redirection_groups.tracking,wp_redirection_modules.id AS module_id FROM wp_redirection_items INNER JOIN wp_redirection_groups ON wp_redirection_groups.id=wp_redirection_items.group_id AND wp_redirection_groups.status='enabled' INNER JOIN wp_redirection_modules ON wp_redirection_modules.id=wp_redirection_groups.module_id AND wp_redirection_modules.type='wp' WHERE (wp_redirection_items.regex=1 OR wp_redirection_items.url='/wp-login.php?action=register&redirect_to=/the-gamers-guide-to-writing-for-games-%e9%88%a5%ef%bf%bd-part-one/' OR wp_redirection_items.url='/wp-login.php?action=register&redirect_to=/the-gamers-guide-to-writing-for-games-鈥�-part-one/') ORDER BY wp_redirection_groups.position,wp_redirection_items.position made by require, require_once, require_once, do_action, call_user_func_array, WordPress_Module->init, Red_Item->get_for_url [04-Jul-2010 21:17:21] PHP Warning: POST Content-Length of 9298668 bytes exceeds the limit of 8388608 bytes in Unknown on line 0 [05-Jul-2010 04:48:54] WordPress database error Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '=' for query SELECT wp_redirection_items.*,wp_redirection_groups.tracking,wp_redirection_modules.id AS module_id FROM wp_redirection_items INNER JOIN wp_redirection_groups ON wp_redirection_groups.id=wp_redirection_items.group_id AND wp_redirection_groups.status='enabled' INNER JOIN wp_redirection_modules ON wp_redirection_modules.id=wp_redirection_groups.module_id AND wp_redirection_modules.type='wp' WHERE (wp_redirection_items.regex=1 OR wp_redirection_items.url='/wp-login.php?action=login&redirect_to=/the-gamers-guide-to-writing-for-games-%e9%88%a5%ef%bf%bd-part-one/' OR wp_redirection_items.url='/wp-login.php?action=login&redirect_to=/the-gamers-guide-to-writing-for-games-鈥�-part-one/') ORDER BY wp_redirection_groups.position,wp_redirection_items.position made by require, require_once, require_once, do_action, call_user_func_array, WordPress_Module->init, Red_Item->get_for_url Code (markup): running latest version 3 wordpress all plugins are up to date any idea whats wrong? Thanks, Ted
Where is your wordpress installed? Is it on the root (yoursite.com) or on a folder (yoursite.com/worpdress) ? Also, are you using English or another language? I honestly think you could get much quicker answers from your host since it seems that you are having conflicting database issues.
I was gonna say the same thing. That doesn't look like a wordpress-problem. It looks more like a database-problem. Contact your host.
yea I have a ticket in with them as well. just the guys / gals here seem to know quite a bit when it comes to wordpress as well. installed in root media stored in separate area. and using English on site. http://game-script.net
This only happens when you click "Profile" ? I don't have a profile so I can't see what you are talking about, but do all other links work fine?
all other links seem to work fine. I might look into the login box widget to see what its doing. other then that seems that sometimes the pages or plugins lose the url on which the site is on, and installed to therefore resulting in removal of the domain from the url bar in browser.