Write Tab MySQL Error

lithium002 · 2011-08-17 20:12:54

Hey everyone,

I recently upgraded a textpattern website from 4.2.0 to 4.4.1 and only just saw today that there is an error being generated when you try to edit an article. This error doesn’t display when you are trying to add a new article, only when you edit an existing article. The error is:

Warning: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'from exc_textpattern where `ID` = '147' limit 1' at line 1 select from exc_textpattern where `ID` = '147' limit 1 in /html/textpattern/lib/txplib_db.php on line 89

I thought this might have to do with PHP settings, so I upgraded to 5 but that didn’t help. I uploaded a fresh copy of the file too, but that didn’t help. Can anyone help? Diagnostics shows no errors.

Last edited by lithium002 (2011-08-18 00:03:37)

ruud · 2011-08-17 20:18:30

Does this happen when you open the existing article or when you try to save the changes?
Do you have admin-side plugins installed that could affect the write tab? (if so, try disabling them).

lithium002 · 2011-08-17 22:05:36

Hey ruud,

Thanks for the response. :)

The error is always there, but it doesn’t affect the modified article (I can modify, open all articles). There are no admin-side plugins that I’m aware of.

ruud · 2011-08-17 22:11:10

Can you post your full diagnostics?
Is 147 (in the error message above) the ID of the article you’re trying to edit?

gfdesign · 2012-08-08 19:23:35

I know it’s an old post, but I have the same error too. This message appears in the bottom, when I’m editing any of articles.
It bears mentioning that my Txp installation uses MLP and “glz_custom_fields” plugins if it helps.

Warning: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'from textpattern where `ID` = '366' limit 1' at line 1 select from textpattern where `ID` = '366' limit 1 in /home/site/public_html/folder/textpattern/lib/txplib_db.php on line 113

This is my diagnostics:

Versión de Textpattern: 4.3.0 (r3451)
Última actualización: 2011-02-10 00:00:57/2012-08-08 04:09:03
Document root: /home/site/public_html/folder
$path_to_site: /home/site/public_html/folder
Ruta a Textpattern: /home/site/public_html/folder/textpattern
Modo de enlace permanente: section_title
Ruta al directorio temporal: /home/site/public_html/folder/textpattern/tmp
URL del sitio: site.com
Versión de PHP: 5.3.8
Biblioteca de imagen GD: bundled (2.0.34 compatible); formatos soportados: GIF, JPG, PNG.
Servidor TZ: America/Buenos_Aires
Tiempo local del servidor: 2012-08-08 16:16:22
¿Activar horario de verano?: 0
¿Ajustar automáticamente la preferencia 'Horario de verano'?: 0
Zona Horaria:  (-10800)
MySQL: 5.1.63-cll
Local: en_GB.UTF-8
Servidor: Apache
PHP Server API: cgi-fcgi
Cabeceras RFC 2616: 0
Sistema operativo del servidor: Linux 2.6.32-71.29.1.el6.x86_64
Plugins activos: jmd_author-0.3, mem_simple_form-0.3.2, cnj_excerpt_logic-0.1, mdn_count-1.4, ob1_pagination-2.5, pm_if_no_articles-0.2, ras_if_article_image-4.1.0, rss_auto_excerpt-0.5m, rss_if_search_results-0.1, rvm_substr-0.3, soo_article_filter-0.2.6, zem_contact_reborn-4.0.3.20, smd_gallery-0.62, zem_nth-0.1, chh_if_data-0.10, mem_glinklist-0.8.5, aks_var-0.2.2b, adi_cat_menu-0.5, stw_category_tree-1.0.1, cbs_category_list-0.9, smd_parent-0.1, srh_file_icon-0.1, zem_contact_lang-mlp-4.0.3.6-ML, lam_browse_by-0.1m, lam_accordion_section-0.2, upm_image-0.6.2, hak_tinymce-0.9.9, ebl-image-edit-2.0, rss_admin_db_manager-4.3, l10n-4.3.0.12, glz_custom_fields-1.3.0, smd_lib-0.36, mem_form-0.8.4, gbp_admin_library-0.4.1, bot_privs-0.3.2, bot_write_tab_customize-0.7, jbx_multiple_image_upload-0.4m, esq_adminsplash-1.01m, bot_file_upload-0.4m, bot_admin_body_class-0.1m, bot_image_upload-0.6.2m
Tema de administración: remora 4.3.0
Comprobación previa: 
------------------------
Algunos archivos de Textpattern han sido modificados: 
	/home/site/public_html/folder/textpattern/lib/txplib_db.php
------------------------
Contenidos del archivo .htaccess: 
------------------------
#DirectoryIndex index.php index.html
#Options +FollowSymLinks
#Options -Indexes
#ErrorDocument 403 default
<IfModule mod_rewrite.c>
	RewriteEngine On
	#RewriteBase /relative/web/path/
	RewriteCond %{REQUEST_FILENAME} -f [OR]
	RewriteCond %{REQUEST_FILENAME} -d
	RewriteRule ^(.+) - [PT,L]
	RewriteCond %{REQUEST_URI} !=/favicon.ico
	RewriteRule ^(.*) index.php
	RewriteCond %{HTTP:Authorization}  !^$
	RewriteRule .* - [E=REMOTE_USER:%{HTTP:Authorization}]
</IfModule>
#php_value register_globals 0

————————————

Any idea?
Thanks

Last edited by gfdesign (2012-08-08 19:28:58)

maniqui · 2012-08-08 20:28:06

Mmmmm… I’ve seen this one before…
I’ll assume that you replaced the txplib_db.php with the one bundled in the MLP, right?
Also, are you running the MLP plugin from the database? (I mean is it installed in the DB or in the plugin cache dir, as a plain .php file?)

Alternatively, I suggest you to download this version of Textpattern 4.4.1, which has the MLP already bundled into it (in other words, you don’t have to replace the txplib_db.php file), and include the necessary plugins (l10n.txt & gbp_admin_library.txt).

https://github.com/maniqui/textpattern/zipball/4.4.1+mlp-4.3.0-12-gb7b6bc0

Notice that this is not the latest official release of MLP, but one that has a few extra commits that got never released officially (don’t know why).
You can see the list of extra commits here:
https://github.com/maniqui/textpattern/blob/4.4.1-mlp/mlp_pack/CHANGELOG

I think one of those extra commits fixes the issue you are currently having.

gfdesign · 2012-08-08 21:46:33

Maniqui, I’ve installed your TXP version that you suggest, but when I do, no there any plugins, even not the MLP plugins into admin side. (So, should I install them manually?)
What I did, was to install your TXP version and then import my DB in there, therefore I see my previous plugins, but not MLP plugins.
Is it correct?
Thanks for your reply.

maniqui · 2012-08-08 23:08:20

Sorry, I may have explained it wrong.
You will find the plugins inside the mlp-4.3.0-12-gb7b6bc0.tar.gz file, which is stored inside the mlp_pack/ folder.
Inside that tar.gz file, there is a plugins/ folder, where you will find l10n.txt & gbp_admin_library.txt, which are the installers for the plugins.
You have to install those two.

gfdesign · 2012-08-09 16:14:49

Apparently, it works fine. I’m glad thank to you!
But the only thing I couldn’t make it works, was “hak_tinymce WYSIWYG article editor” plugin that it came working good until the updating.
Have you happened the same to you ?. I tried re install again but without success. I’ll find out what can else I do.
Thanks again.

maniqui · 2012-08-09 16:16:32

I don’t use hak_tinymce, so I can’t tell you what could be going on. Does the browser console show any Javascript error?

gfdesign · 2012-08-09 16:29:54

No, it doesn’t. Up to now, I haven’t seen any .js error :)
One question. What do you do when your clients ask be able give format to their texts? They use just plain text? Maybe Textile?
Personally, this one I don’t like too much in spite of knowing it generates clean HTML

EDIT:
I could solve it. There were some missed files to be uploaded.
Now every works fine!
My mistake. Sorry! :D
Thanks!

Last edited by gfdesign (2012-08-09 18:39:25)

Textpattern CMS

Textpattern CMS support forum

#1 2011-08-17 20:12:54

Write Tab MySQL Error

#2 2011-08-17 20:18:30

Re: Write Tab MySQL Error

#3 2011-08-17 22:05:36

Re: Write Tab MySQL Error

#4 2011-08-17 22:11:10

Re: Write Tab MySQL Error

#5 2012-08-08 19:23:35

Re: Write Tab MySQL Error

#6 2012-08-08 20:28:06

Re: Write Tab MySQL Error

#7 2012-08-08 21:46:33

Re: Write Tab MySQL Error

#8 2012-08-08 23:08:20

Re: Write Tab MySQL Error

#9 2012-08-09 16:14:49

Re: Write Tab MySQL Error

#10 2012-08-09 16:16:32

Re: Write Tab MySQL Error

#11 2012-08-09 16:29:54

Re: Write Tab MySQL Error

Board footer