vb.org Archive - Administrative and Maintenance Tools

Page 50 of 87

Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vBulletin 4.x Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=245)

- - Administrative and Maintenance Tools - Template Modification System (https://vborg.vbsupport.ru/showthread.php?t=152931)

TaMpE

02-24-2009 12:51 AM

Quote:

Originally Posted by Black Tiger (Post 1752680)

You can choose one you like.
For example you could make varname "cybfruleslink" so thatway you know, when searching the templates later, for which mod you made the entry.

Thank you mate, now it works better. I got a DB error when I tried to guess lol

Videx

02-24-2009 02:05 AM

Over the weekend I changed every single table to latin1_swedish_ci manually. The db is set to latin1_swedish_ci. So why am I still getting the same error?

Quote:

Database error in vBulletin 3.8.1:

Invalid SQL:

SELECT templateid, searchstrregex, replacestr
FROM templateedit AS templateedit
INNER JOIN templateeditlocation AS templateeditlocation ON (templateeditlocation.varname=templateedit.varname )
INNER JOIN template AS template ON (template.title=templateeditlocation.template)
LEFT JOIN style AS style ON (style.styleid=template.styleid AND FIND_IN_SET(templateedit.templateeditid, style.templateeditlist))
LEFT JOIN product AS product ON (product.productid=templateeditlocation.product)
WHERE (NOT ISNULL(style.styleid) OR (templateedit.styleid=-1 AND template.styleid=-1))
AND (product.active=1 OR templateeditlocation.product='vbulletin')
AND templateedit.active = 1
AND template.title IN ('footer')

ORDER BY searchorder ASC;

MySQL Error : Illegal mix of collations (latin1_general_ci,IMPLICIT) and (latin1_swedish_ci,IMPLICIT) for operation '='
Error Number : 1267
Request Date : Monday, February 23rd 2009 @ 11:01:11 PM
Error Date : Monday, February 23rd 2009 @ 11:01:12 PM
Script : admincp/plugin.php?do=productimport
Referrer : admincp/plugin.php?do=productadd
Classname : vB_Database
MySQL Version : 4.1.22-standard-log

Andreas

02-24-2009 06:57 AM

Quote:

So why am I still getting the same error?

Check the collations for

templateeditlocation.varname
templateedit.varname
template.title
templateeditlocation.template
product.productid
templateeditlocation.product

Are they all the same?

Videx

02-24-2009 10:08 AM

All the varnames are latin1.bin. template.title and product.productid is still general, despite the table itself now being swedish. Silly me, thinking changing a table would of course change it's contents!

So, should I try changing yet more items manually?

Andreas

02-24-2009 11:11 AM

Make sure the columns used in the conditions are compatible (eg. templateeditlocation.varname=templateedit.varname, template.title=templateeditlocation.template and product.productid=templateeditlocation.product)

Videx

02-24-2009 07:31 PM

Done, but I still get an error:

Quote:

Database error in vBulletin 3.8.1:

Invalid SQL:

SELECT plugin.*,
IF(product.productid IS NULL, 0, 1) AS foundproduct,
IF(plugin.product = 'vbulletin', 1, product.active) AS productactive
FROM plugin AS plugin
LEFT JOIN product AS product ON(product.productid = plugin.product)
WHERE plugin.active = 1
AND plugin.phpcode <> ''
ORDER BY plugin.executionorder ASC;

MySQL Error : Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (latin1_general_ci,IMPLICIT) for operation '='

Worse, when I checked my inbox a whole slew of cron errors were there, so I've set product.productid back to general:

Quote:

Invalid SQL:

SELECT cron.*
FROM cron AS cron
LEFT JOIN product AS product ON (cron.product = product.productid)
WHERE cron.nextrun <= 1235509743 AND cron.active = 1
AND (product.productid IS NULL OR product.active = 1)
ORDER BY cron.nextrun
LIMIT 1;

MySQL Error : Illegal mix of collations (latin1_general_ci,IMPLICIT) and (latin1_swedish_ci,IMPLICIT) for operation '='

I wonder if I shouldn't be thinking more in terms of converting this entire db to something? But what? And how?

Andreas

02-25-2009 04:02 AM

Well, all I can say is: Fix your database.

product.productid must be the compatible with plugin.product and cron.product (and phrase.product, setting.product, productcode.productid, faq.product, ... you get the idea?)
All those standard fields really should already be the same (otherwise you would have gotten errors earlier).
With a standard MySQL installation they will most likely be latin1_swedish_ci

I suggest to export your DB schema and attach it here, that would make it a lot easier to point out which fields/tables do have the wrong collation.

redraider

03-08-2009 08:08 PM

Hi andreas, Thanks for this great modification. I have suddenly started getting a strange problem - There are a few template modifications that do not show inside "Master Style", but only in my customized styles, but when I click on the modification I get this error:

"The Template-Modification called 'Remove Navbar' can not be customized in this style because the template 'VBDRUPAL' is not customized in this style."

BUT my master style doesnt have a REMOVE NAVBAR modification listed ... how do I edit this ??

Please help!

Videx

03-14-2009 10:34 AM

I finally managed to fix my illegal mix of collations. I posted the solution here.

TheSupportForum

03-14-2009 05:35 PM

is therea tutorials to add own template edits to work with thisa program

All times are GMT. The time now is 10:29 PM.

Page 50 of 87

« First

Last »

Show 40 post(s) from this thread on one page

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.04194 seconds Memory Usage 1,744KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (5)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (2)pagenav_pagelinkrel (1)post_thanks_navbar_search (1)printthread (10)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start pagenav_page pagenav_complete bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: