Textpattern CMS

#1 2012-12-20 18:37:40

Zanza

Plugin Author

Registered: 2005-08-18

Posts: 699

Website

Can't see section list + error msg in admin section page

My first try with 4.5.x, using 4.5.4. Fresh install on a test server. Everything ok BUT a big problem: I can’t get my section list & settings in the section admin page.

I get this error:

Errore interno "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 'SELECT count(*) FROM textpattern articles WHERE articles.Sectio"
in /web/htdocs/www.XXXXX.COM/home/_stage/textpattern/lib/txplib_db.php at line 95.

adminErrorHandler()
textpattern/lib/txplib_db.php:95 trigger_error()
textpattern/lib/txplib_db.php:320 safe_query()
textpattern/lib/txplib_db.php:258 startRows()
textpattern/include/txp_section.php:177 safe_rows_start()

To be honest, this message only come with the hive theme, because classic is giving me less details and only with an alertbox… Anyway, the problem is that I can’t get the section list and I can’t add one, change template, etc.

Diagnostic says php 5.3.19, MySQL: 4.0.30-standard-log
Locale: it_IT.UTF-8.

Php extensions: Core/5.3.19, date/5.3.19, ereg, libxml, openssl, pcre, sqlite3/0.7-dev, zlib/1.1, bcmath, bz2, calendar, ctype, curl, dom/20031129, hash/1.0, fileinfo/1.0.5-dev, filter/0.11.0, ftp, gd, gettext, SPL/0.2, iconv, session, json/1.2.1, mbstring, mcrypt, mysql/1.0, mysqli/0.1, standard/5.3.19, PDO/1.0.4dev, pdo_mysql/1.0.2, pdo_sqlite/1.0.1, Phar/2.0.1, posix, Reflection/$Id: 593a0506b01337cfaf9f63ebc12cd60523fc2c41 $, imap, SimpleXML/0.1, soap, SQLite/2.0-dev, exif/1.4 $Id$, tokenizer/0.1, wddx, xml, xmlreader/0.1, xmlwriter/0.1, xsl/0.1, cgi-fcgi, imagick/3.0.1, SourceGuardian/9.0, ffmpeg/0.6.0-svn, tidy/2.0, mhash, ionCube Loader

Let me know if I can post something else to help.

Thanks

Z-

#2 2013-02-02 15:09:11

uli

Moderator

From: Cologne

Registered: 2006-08-15

Posts: 4,306

Re: Can't see section list + error msg in admin section page

Zanza, somehow we managed to miss this post in the days before Christmas, sorry. There’s an ongoing discussion ATM over here which might be related with what you experience(d). Could you already spot the cause of your problem?

---

_{In bad weather I never leave home without wet_plugout, smd_where_used and adi_form_links}

#3 2013-02-02 15:14:22

uli

Moderator

From: Cologne

Registered: 2006-08-15

Posts: 4,306

Re: Can't see section list + error msg in admin section page

If you think the neighboured topic sounds like it’s your issue, I’d ask you to post over there as there’s some content already. Thanks.
Oh, and complete diagnostics might be useful for comparisons.

---

_{In bad weather I never leave home without wet_plugout, smd_where_used and adi_form_links}