Not Solved Trying to reinstall My Advertisements 2.3.3
#1
Not Solved
IHello, I want to reinstall My Advertisements 2.3.3 plugin but i got it this error:



MyBB has experienced an internal SQL error and cannot continue.
SQL Error: 1366 - Incorrect integer value: '' for column 'sid' at row 1 Query: INSERT INTO mybb_settings (`sid`,`name`,`title`,`description`,`optionscode`,`value`,`disporder`,`gid`) VALUES ('','myadvertisements_disabled','Advertisements disabled?','Set to yes if you want to disable all advertisements.','yesno',0,1,78) 

[b]If you're a visitor of this website[/b], please wait a few minutes and try again. If this problem persists, please [url=http://site.com/forums/contact.php]contact the site owner[/url]. 
[b]If you are the site owner[/b], please check the [url=https://docs.mybb.com]MyBB Documentation[/url] for help resolving [url=https://docs.mybb.com/1.8/faq/]common issues[/url], or get technical help on the [url=https://community.mybb.com/]MyBB Community Forums[/url].



First time working fine, but nowI don;t know what's happening



mod_security is disabled



Anyone can help me? I give you a coffe, thanks
Reply
#2
Not Solved
In the plugin, you may have lines looking like 'sid' => '',. Remove them and try to reinstall.
[MyBB 1.8 mods] - Offer me a coffee
Do not ask me help through PM
Reply
#3
Not Solved
(2021-06-04, 08:09 AM)Crazycat Wrote: In the plugin, you may have lines looking like 'sid' => '',. Remove them and try to reinstall.

i removed all `'sid' => '' from all pages, and receive same error

MyBB has experienced an internal SQL error and cannot continue.

SQL Error:
1064 - 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 ') ORDER BY tid DESC' at line 1
Query:
SELECT tid, DATE_FORMAT(FROM_UNIXTIME(lastpost),'%Y-%m-%dT%H:%i:%sZ') AS lastmod FROM mybb_threads WHERE NOT dateline = 0 AND fid NOT IN () ORDER BY tid DESC
If you're a visitor of this website, please wait a few minutes and try again. If this problem persists, please contact the site owner.

If you are the site owner, please check the MyBB Documentation for help resolving common issues, or get technical help on the MyBB Community Forums.
[url=https://community.mybb.com/user-140794.html][/url]
Reply
#4
Not Solved
Whatever is throwing that error, it's not coming from the MyAdvertisements plugin.
There is no query like that in there at all.

You said
Quote:i removed all `'sid' => '' from all pages
and I note "all pages" is plural. Just what did you do? Crazycat's reference was to the MyAdvertisements plugin.
Reply
#5
Not Solved
The new trouble has already been reported here, I had gave a correction but it's too late tonight for me to search when and where.
But globaly, the correction was to look if there is non-readable thread, and if not, remove the fid NOT IN () part of the query.

Edit the trouble was in fact with another plugin, but exactly the same. See https://community.mybb.com/thread-232368...pid1366759 for explanation.
[MyBB 1.8 mods] - Offer me a coffee
Do not ask me help through PM
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)