Textpattern CMS support forum
You are not logged in. Register | Login | Help
- Topics: Active | Unanswered
#1 2023-01-11 17:36:58
- pexman
- Member
- Registered: 2016-02-27
- Posts: 63
DB column 'log' suddenly and unexpectedly
User_Error “Unknown column ‘ip’ in ‘light00_txp_log’”
there are no entries in the ‘log’ table
I always get this error displayed in the admin panel. After that I did an update to 4.8.8
The page works. How do I get rid of the error message. Below it still says:
textpattern/lib/txplib_admin.php:772 adminErrorHandler()
updateErrorHandler()
textpattern/lib/txplib_db.php:453 trigger_error()
textpattern/lib/txplib_db.php:588 safe_query()
textpattern/update/_to_4.5.7.php:32 safe_alter()
textpattern/update/_update.php:101 include()
textpattern/index.php:177 include()
it has nothing to do with the update, because the error came before.
Offline
Re: DB column 'log' suddenly and unexpectedly
Are you using any plugins that might collect or process IP addresses? We removed the column in Txp 4.7.0 a long time ago.
The smd plugin menagerie — for when you need one more gribble of power from Textpattern. Bleeding-edge code available on GitHub.
Txp Builders – finely-crafted code, design and Txp
Offline
#3 2023-01-11 17:53:44
- pexman
- Member
- Registered: 2016-02-27
- Posts: 63
Re: DB column 'log' suddenly and unexpectedly
I have a little yab_shop and also a cooky popup. I don`t think, that it grabs an id. That is all. Should I delete this table?
Offline
Re: DB column 'log' suddenly and unexpectedly
Deleting the table might be a bit drastic!
Can you temporarily disable the plugins one by one without impacting your site too much? Just to see if the error goes away and if so, which plugin we need to hack.
The smd plugin menagerie — for when you need one more gribble of power from Textpattern. Bleeding-edge code available on GitHub.
Txp Builders – finely-crafted code, design and Txp
Offline
#5 2023-01-11 18:12:46
- pexman
- Member
- Registered: 2016-02-27
- Posts: 63
Re: DB column 'log' suddenly and unexpectedly
Not possible? I get:
Sorry, the form could not be submitted. Please try again later.
Offline
#6 2023-01-11 18:21:56
- pexman
- Member
- Registered: 2016-02-27
- Posts: 63
Re: DB column 'log' suddenly and unexpectedly
the last plugin, I installed, was smd_tags. The error came when I was working with this tags. The plugin makes new tables in the db. But I worked with it since 3 days, without complication.
Offline
#7 2023-01-11 18:29:12
- pexman
- Member
- Registered: 2016-02-27
- Posts: 63
Re: DB column 'log' suddenly and unexpectedly
okay, I can begin to take off the plugs.
Offline
#8 2023-01-11 18:50:34
- pexman
- Member
- Registered: 2016-02-27
- Posts: 63
Re: DB column 'log' suddenly and unexpectedly
yab_shop take off, nothing happend, when I load the browser new. I loged out, after in again, then I activated the plug ins, and when I logged out, and in again, it wasn`t possible.
the website is functional except for the yab_shop. I can order a merchandise, the shopping cart shows the total, but when I then “go” to the checkout, no order is displayed there.
This error I get, when I want to login on admin-page.
Fatal error: Uncaught Error: Call to undefined function mysql_num_rows() in /var/www/vhosts/arteurope.de/arteurope.de/textpattern/plugins/yab_shop_add_language_de-de/yab_shop_add_language_de-de.php:4 Stack trace: #0 /var/www/vhosts/arteurope.de/arteurope.de/textpattern/lib/txplib_misc.php(1479): include() #1 /var/www/vhosts/arteurope.de/arteurope.de/textpattern/index.php(212): load_plugins() #2 {main} thrown in /var/www/vhosts/arteurope.de/arteurope.de/textpattern/plugins/yab_shop_add_language_de-de/yab_shop_add_language_de-de.php on line 4
Last edited by pexman (2023-01-11 18:53:02)
Offline
Re: DB column 'log' suddenly and unexpectedly
Okay, well that last error is due to PHP incompatibility. Which version of yab,_shop is it? I presume the latest 0.8.5? If so, I thought trenc had patched it for mysqli_* calls.
If you want to play with installing, enabling or disabling misbehaving plugins, add ?event=plugin (or it could be plugins, I never remember) to the URL and it’ll drop you on the plugins panel when you successfully log in.
The smd plugin menagerie — for when you need one more gribble of power from Textpattern. Bleeding-edge code available on GitHub.
Txp Builders – finely-crafted code, design and Txp
Offline
#10 2023-01-11 20:36:52
- pexman
- Member
- Registered: 2016-02-27
- Posts: 63
Re: DB column 'log' suddenly and unexpectedly
Unfortunately, I can’t log in now. But I can access the database. I can edit the records.
Offline
#11 2023-01-11 20:47:10
- pexman
- Member
- Registered: 2016-02-27
- Posts: 63
Re: DB column 'log' suddenly and unexpectedly
I tried downgrading PHP to 7.4.30, but it has no effect. But I also get into the folder of textpattern/plugins and can edit the yab folders.
Offline
#12 2023-01-12 00:00:00
- pexman
- Member
- Registered: 2016-02-27
- Posts: 63
Re: DB column 'log' suddenly and unexpectedly
I can log in again. For this I had to delete some lines in /textpattern/plugins/yab_shop_add_language_en/yab_shop_add_language_en.php.
<?php
if (@txpinterface == ‘admin’)
{ if (mysql_num_rows(safe_query(“SHOW TABLES LIKE ‘”.PFX. “yab_shop_lang’”))) { $yab_shop_lang_code = ‘en-de’;if (!safe_count(‘yab_shop_lang’, “lang=’”.doSlash($yab_shop_lang_code).”’)) { yab_shop_add_language($yab_shop_lang_code); } else { return false; } } else { return false; }
} …I had to delete the first part and of course the bracket further down:
<?php
if (@txpinterface == ‘admin’)
{if (!safe_count(‘yab_shop_lang’, “lang=’”.doSlash($yab_shop_lang_code).”’”)) { yab_shop_add_language($yab_shop_lang_code); } else { return false; }
} …
Last edited by pexman (2023-01-12 00:01:25)
Offline