getting database errors when posting or if attaching a picture .

[Doug Heffernan]

hi doug yes i updated to smf 2.1.2 . yes i might just do as you suggest and put in a clean file set . and then see what errors i get . i have the database checker tool , i did try it out , i think i posted here about it on this thread , but i cant remember . just could not seem to work out how to use it to clean up the database . i mean i read up on it and what it should do and show . but AGAIN for me (for me its always the hard way it seems ) the tool did not do or show what the instructions said it should . but i will try it all again and report back . thanks doug .

Reading at that tool 's topic, it will list all the custom stuff added by mods.

Once you have uninstalled all the mods, make a list of the one that you want to keep using as you do not need to remove their stuff from the database. Only the stuff added by the old and unused mods.

But first of all, do not forget to make a backup of your database before you modify it.

[geminiman]

ok i put im a clean file set . i ran the upgrade tool whether i needed to or not . it stopped again at COVERT TO UT8F , it converted not one thing and never moved after that . so this keeps happening .

still getting cron and database errors , the same ones listed in this thread .

tried (was just curious) to attach a file , a screenshot to a test post . all goes fine till you click on UPLOAD . but then i get a massive bank of red code , looks like html , again i posted this red bank of code in this thread . interesting the upload option was gone for a while but now it has returned . but attachment failed .

i ran database compare tool . to honest while i know from the tools thread that red lines are delete , green are adds from mods . but all that said ive no idea what im looking for in the tool . and no idea what i should do .can you tell me what i should be looking for and how i would go about removing it  .

interestingly database tool is showing lots of tables as non ut8f when i know i converted them all the other day .

i will attach a screen shot of database tool . i can give you access to my site or host doug if you need it . i mean if that makes it easier for you to see the problem . the screen shot would be huge so i decided to just upload a segment of green adds related to attachments . as attachments are a major problem as we cant attach anything . as i say im at a loss as to what i should be doing . i cant see anywhere for example where the file says go to a specific location and remove a line of code or a file for example . if i know what to do i can usually do it . thanks doug

[geminiman]

hi doug if you are around . the errors on the site seem to have decreased a lot . i had on your instructions uploaded a clean file set . and i noticed two things , A / that the character set had reverted back in a lot of cases to what it had been , and not ut8f , so i had to reset that again to ut8f , so that is done . and B/ the expire date filed in attachments returned. i again changed the default value , and then dropped the field again to no avail . meaning that i still cant attach any files or images to a post . obviously this is an important function , ive spent a lot of time looking and reading but im just at a loss as to how to resolve this issue .

i get the same error over and over even tho the expire_date field has been dropped

Field 'expire_date' doesn't have a default value
File: /home3/boxkings/public_html/Sources/Subs-Attachments.php
Line: 781

but as i say the number and frequency of errors has decreased (which is a plus ) it was going up by 900 to 1000 a day , it currently sits at just 86 and that is over a a few days now and all are the same error now (which i will post just below . the errors were a mixture of general , cron , database , now its just saying database .

if i understand what i read correctly incorrect string value error is related to character set / encoding . i have all tables set to ut8f as per instructions , and yet i still get these errors .

Type of error: Database
: Incorrect string value: '\xE0\xAE\x9A\xE0\xAE\xBF...' for column 'value' at row 1
https://www.satbox.info/cron.php

earlier in this thread you mentioned removing hooks , i can remove all hooks using repair_settings tool . but i need to know is this advisable ? , what will that achieve if anything ? , will it help with the problem i am having .
/home3/boxkings/public_html/Sources/Subs.php (Line 529)

i have used the smf database compare tool , i can see green adds related to attachments , including the expire field , but maybe i am stupid but i just cant see any info there that tells me where i should look (file path or host wise etc etc ) and what if anything i should remove. so on this im just a bit lost .

EDIT:

ive popped in fix_packages.php tool

its shows me obviously the installed packages / mods on my site . but also its hows me all uninstalled packages / mods going back years . funny thing i noticed is the uninstall dates on some mods

Priority timezones plus    1.1    2022-05-11 10:23   
Attachment Browser    1.7    1970-01-01 01:00   
SoundCloud Embed Widget    1.3    1970-01-01 01:00   
SMF Gallery Lite    6.0    1970-01-01 01:00   
Priority timezones plus    1.1    2022-05-11 10:31

the above is just a small selection of the listed uninstalled packages .

as you can see some are saying uninstalled in 1970 , how can that be ? . but my question here is if i select each and every UNINSTALLED package in the list by placing a tick in each box and then hit remove all hooks will that help with my problems ? or could that have an adverse affect ? . sorry for all the questions , im just trying out new things , seeing what i can see , and trying to learn in the hopes i can resolve my issues ? . thanks as always for any help or advice.

[Doug Heffernan]

i had on your instructions uploaded a clean file set . and i noticed two things , A / that the character set had reverted back in a lot of cases to what it had been , and not ut8f , so i had to reset that again to ut8f , so that is done

Overwriting the forum files does not revert the database collation character. That is simply not possible.

if i understand what i read correctly incorrect string value error is related to character set / encoding . i have all tables set to ut8f as per instructions , and yet i still get these errors .

Type of error: Database
: Incorrect string value: '\xE0\xAE\x9A\xE0\xAE\xBF...' for column 'value' at row 1
https://www.satbox.info/cron.php

Personally I think that the utf-8 conversion is not done properly, otherwise the aforementioned error should not occur.

and B/ the expire date filed in attachments returned.

Again, just like with the utf-8 conversion, overwriting of the forum files should not add or remove stuff from the database.

i get the same error over and over even tho the expire_date field has been dropped

Field 'expire_date' doesn't have a default value
File: /home3/boxkings/public_html/Sources/Subs-Attachments.php
Line: 781

If the aforementioned filed has been removed, and the mod that has added it has been uninstalled as well, the error should not occur anymore. The only reason that I can think of is that said field has not been removed from the right database or table.

[geminiman]

hi doug i hear what you are saying but what i am telling you is accurate . having put in a clean file set i noticed that tables were again saying latin etc . so they are now back to ut8f .

and again the field in question (expire date ) was dropped by me several posts back . having put in the clean file set it returned . i have since again tried to change the default value NO GOOD , and i dropped the field AGAIN . i even posted a screenshot some posts back in this regard .

there is an older database that is not used , im not even sure why its there , the old admin / tech guy is responsible for that . but just to cross the Ts etc i converted that to utf8 and i checked the attachments table for the expire date field , the field is not in it . 

EDIT :

ok just to know that i am not going crazy here , and that what i am seeing and saying is accurate . there are several databases . only two are in use with two very different names . one was never really used it was just set up as a test . the others have not been in use for some time . but just to be certain all databases now are converted to utf8 . and NONE of the other databases has the expire date field in it . that is for 100% certain . so in the ONLY database that had that field that field was dropped , it was gone , then after add a clean file set it returned , and as i said i dropped it again .

so what i am saying is accurate even if it sounds crazy , but it is accurate .

[Doug Heffernan]

hi doug i hear what you are saying but what i am telling you is accurate . having put in a clean file set i noticed that tables were again saying latin etc . so they are now back to ut8f .

The thing is that when you overwrite the forum files with those of the large upgrade package of your forum version, the only thing happening is that your forum files get freshened up and all the custom mods and manual edits get uninstalled/undone.

That is all. It will not alter the database by undoing the collation character or readding a deleted database field. That is simply not possible because the process of the files overwriting as described above, does not touch the database at all.

ok just to know that i am not going crazy here , and that what i am seeing and saying is accurate . there are several databases . only two are in use with two very different names . one was never really used it was just set up as a test . the others have not been in use for some time . but just to be certain all databases now are converted to utf8 . and NONE of the other databases has the expire date field in it . that is for 100% certain . so in the ONLY database that had that field that field was dropped , it was gone , then after add a clean file set it returned , and as i said i dropped it again .

You can get the name of the right database from your Settings.php file. That is the database that you need.

Important: Besides the overwriting of the forum files, are you restoring a database backup as well from before the issues by any chance? Because that is the only reason that I can think of for the collation characters to be reverted and for the deleted database field to be re added back.

[geminiman]

hi doug i had the correct database , 100% certain . just to be certain i did as you asked and checked settings file . even tho i already knew . but i just want to cover all bases .

so its the correct database . the database was restored by my host as you know back when we had the original problem . this must be about a month back i should think , perhaps more .

i do understand what you are saying about the clean file set , i understand that it should not alter the database , i get that . but just to prove a point i just went off and put in a clean file set again . i ran upgrade.php and again as it has done every single time it stopped at the point it is supposed to updated tables to utf8 , which is at about the 73% mark in the progress bar .

i went to my host and checked the databases , all of them show utf8 .so the character set did not change .however  i then opened the main database (the database for my main site that has the issues ) i went to attachments table , and what did i find AGAIN ? i found that the expire date table that i have dropped i think 3 times now has again returned , i dropped it again . still my site wont let me attach any files and it still gives me the errors . here they are .

Code Select Expand

4
Today at 16:30
Guest
https://www.satbox.info/cron.php
/home3/boxkings/public_html/Sources/Subs.php (Line 529)
Backtrace information

Type of error: Database
Error message Select Expand
: Incorrect string value: '\xE0\xAE\x9A\xE0\xAE\xBF...' for column 'value' at row 1


REPLACE INTO boxkingssatellite_settings(`variable`, `value`)
VALUES
(SUBSTRING('tld_regex', 1, 255), SUBSTRING('(?>சிங்கப்பூர்|پاکستان|فلسطين|ファッション|ישראל|همراه|संगठन|বাংলা|భారత్|ഭാരതം|дети|تونس|شبكة|ڀارت|ਭਾਰਤ|ભારત|ଭାରତ|ಭಾರತ|ලංකා|アマゾン|クラウド|グーグル|ポイント|组织机构|電訊盈科|укр|қаз|հայ|קום|قطر|कॉम|नेट|भार(?>ोत|त(?>म्|))|คอม|ไทย|ລາວ|みんな|ストア|セール|亚马逊|天主教|我爱你|淡马锡|诺基亚|飞利浦|ею|سو(?>دان|رية)|ভা(?>রত|ৰত)|გე|コム|世界|企业|佛山|信息|健康|八卦|嘉里(?>大酒店|)|在线|大拿|娱乐|家電|广东|微博|慈善|手机|招聘|时尚|書籍|机构|游戏|澳門|点看|移动|联通|谷歌|购物|通販|集团|食品|餐厅|삼성|한국|a(?>vianca|kdn|a(?>rp|a)|b(?>udhabi|ogado|arth|le|b(?>ott|vie|)|c)|c(?>ademy|tor|c(?>ountant(?>s|)|enture)|o|)|d(?>ult|ac|s|)|e(?>tna|ro|g|)|f(?>rica|l|)|g(?>akhan|ency|)|i(?>g|r(?>force|bus|tel)|)|l(?>faromeo|i(?>baba|pay)|l(?>finanz|state|y)|s(?>ace|tom)|)|m(?>sterdam|azon|fam|ica|e(?>rican(?>express|family)|x)|)|n(?>alytics|droid|quan|z)|o(?>l|)|p(?>artments|p(?>le|))|q(?>uarelle|)|r(?>chi|my|pa|a(?>mco|b)|t(?>e|)|)|s(?>sociates|da|ia|)|t(?>torney|hleta|)|u(?>ction|spost|di(?>ble|o|)|t(?>hor|o(?>s|))|)|w(?>s|)|x(?>a|)|z(?>ure|))|b(?>a(?>uhaus|yern|idu|by|n(?>a(?>narepublic|mex)|d|k)|r(?>efoot|gains|c(?>elona|lay(?>card|s))|)|s(?>ketball|eball)|)|b(?>va|c|t|)|c(?>g|n)|d|e(?>ntley|rlin|er|st(?>buy|)|a(?>uty|ts)|t|)|f|g|h(?>arti|)|i(?>ble|ke|ng(?>o|)|d|o|z|)|j|l(?>ack(?>friday|)|ue|o(?>ckbuster|omberg|g))|m(?>s|w|)|n(?>pparibas|)|o(?>ehringer|utique|ats|fa|nd|m|o(?>k(?>ing|)|)|s(?>ch|t(?>ik|on))|t|x|)|r(?>idgestone|adesco|ussels|o(?>adway|ther|ker)|)|s|t|u(?>siness|gatti|ild(?>ers|)|zz|y)|v|w|y|z(?>h|))|c(?>pa|a(?>fe|b|l(?>vinklein|l|)|m(?>era|p|)|n(?>cerresearch|on)|p(?>etown|ital(?>one|))|r(?>avan|ds|e(?>er(?>s|)|)|s|)|s(?>ino|a|e|h)|t(?>ering|holic|)|)|b(?>re|a|n|s)|c|d|e(?>nter|rn|o)|f(?>a|d|)|g|h(?>intai|urch|eap|a(?>rity|se|n(?>nel|el)|t)|r(?>istmas|ome)|)|i(?>priani|rcle|sco|t(?>adel|i(?>c|)|y(?>eats|))|)|k|l(?>eaning|aims|ub(?>med|)|i(?>ck|ni(?>que|c))|o(?>thing|ud)|)|m|n|o(?>rsica|ffee|ach|des|l(?>lege|ogne)|m(?>cast|sec|m(?>unity|bank)|p(?>uter|a(?>ny|re))|)|n(?>dos|s(?>truction|ulting)|t(?>ractors|act))|o(?>king(?>channel|)|l|p)|u(?>ntry|rses|pon(?>s|))|)|r(?>icket|edit(?>union|card|)|uise(?>s|)|own|s|)|u(?>isinella|)|v|w|x|y(?>mru|ou|)|z)|d(?>rive|clk|ds|hl|np|tv|a(?>bur|nce|d|t(?>ing|sun|a|e)|y)|e(?>mocrat|gree|al(?>er|s|)|nt(?>ist|al)|si(?>gn|)|l(?>ivery|oitte|ta|l)|v|)|i(?>amonds|gital|rect(?>ory|)|et|s(?>co(?>unt|ver)|h)|y)|j|k|m|o(?>wnload|mains|c(?>tor|s)|g|t|)|u(?>nlop|pont|rban|bai)|v(?>ag|r)|z)|e(?>quipment|vents|pson|a(?>rth|t)|c(?>o|)|d(?>eka|u(?>cation|))|e|g|m(?>erck|ail)|n(?>terprises|gineer(?>ing|)|ergy)|r(?>icsson|ni|)|s(?>tate|q|)|t(?>isalat|)|u(?>rovision|s|)|x(?>traspace|change|p(?>osed|ress|ert)))|f(?>tr|yi|a(?>mily|ge|rm(?>ers|)|i(?>rwinds|th|l)|n(?>s|)|s(?>hion|t))|e(?>edback|dex|rr(?>ari|ero))|i(?>at|lm|na(?>nc(?>ial|e)|l)|sh(?>ing|)|d(?>elity|o)|r(?>mdale|e(?>stone|))|t(?>ness|)|)|j|k|l(?>i(?>ghts|ckr|r)|o(?>rist|wers)|y)|m|o(?>undation|o(?>tball|d(?>network|)|)|r(?>sale|ex|um|d)|x|)|r(?>e(?>senius|e)|l|o(?>gans|nt(?>door|ier))|)|u(?>rniture|jitsu|tbol|n(?>d|)))|g(?>a(?>rden|me(?>s|)|l(?>l(?>ery|up|o)|)|p|y|)|b(?>iz|)|d(?>n|)|e(?>orge|nt(?>ing|)|a|)|f|g(?>ee|)|h|i(?>ft(?>s|)|v(?>ing|es)|)|l(?>ass|ob(?>al|o)|e|)|m(?>ail|bh|o|x|)|n|o(?>daddy|l(?>d(?>point|)|f)|o(?>dyear|g(?>le|)|)|p|t|v)|p|q|r(?>een|ipe|a(?>inger|phics|tis)|o(?>cery|up)|)|s|t|u(?>ardian|cci|ge|ru|i(?>tars|de)|)|w|y)|h(?>dfc(?>bank|)|gtv|sbc|bo|a(?>mburg|ngout|ir|us)|e(?>alth(?>care|)|l(?>sinki|p)|r(?>mes|e))|i(?>samitsu|tachi|phop|v)|k(?>t|)|m|n|o(?>ckey|nda|rse|use|me(?>depot|goods|s(?>ense|))|l(?>dings|iday)|s(?>pital|t(?>ing|))|t(?>mail|el(?>es|s)|)|w)|r|t|u(?>ghes|)|y(?>undai|att))|i(?>piranga|kano|bm|fm|c(?>bc|e|u)|d|e(?>ee|)|l|m(?>amat|db|mo(?>bilien|)|)|n(?>vestments|dustries|c|f(?>initi|o)|g|k|s(?>titute|ur(?>ance|e))|t(?>ernational|uit|)|)|o|q|r(?>ish|)|s(?>maili|t(?>anbul|)|)|t(?>au|v|))|j(?>cb|io|ll|nj|a(?>guar|va)|e(?>welry|tzt|ep|)|m(?>p|)|o(?>b(?>urg|s)|t|y|)|p(?>morgan|rs|)|u(?>niper|egos))|k(?>uokgroup|aufen|ddi|fh|e(?>rry(?>properties|logistics|hotels)|)|g|h|i(?>tchen|ds|nd(?>er|le)|wi|a|m|)|m|n|o(?>matsu|sher|eln)|p(?>mg|n|)|r(?>ed|d|)|w|y(?>oto|)|z)|l(?>gbt|ds|pl(?>financial|)|a(?>caixa|salle|m(?>borghini|er)|n(?>xess|c(?>aster|ia)|d(?>rover|))|t(?>robe|ino|)|w(?>yer|)|)|b|c|e(?>clerc|frak|ase|xus|g(?>al|o))|i(?>ghting|lly|psy|dl|fe(?>insurance|style|)|ke|m(?>ited|o)|n(?>coln|de|k)|v(?>ing|e)|)|k|l(?>c|p)|o(?>ndon|an(?>s|)|ft|tt(?>e|o)|ve|c(?>ker|al|us)|l)|r|s|t(?>d(?>a|)|)|u(?>ndbeck|x(?>ury|e)|)|v|y)|m(?>ba|a(?>serati|drid|keup|ttel|cys|i(?>son|f)|n(?>agement|go|)|p|r(?>shalls|riott|ket(?>ing|s|))|)|c(?>kinsey|)|d|e(?>lbourne|rckmsd|et|d(?>ia|)|m(?>orial|e)|n(?>u|)|)|g|h|i(?>crosoft|ami|l|n(?>i|t)|t(?>subishi|))|k|l(?>b|s|)|m(?>a|)|n|o(?>scow|bi(?>le|)|da|to(?>rcycles|)|e|i|m|n(?>ster|ash|ey)|r(?>tgage|mon)|v(?>ie|)|)|p|q|r|s(?>d|)|t(?>n|r|)|u(?>tual|s(?>eum|ic)|)|v|w|x|y|z)|n(?>ba|hk|tt|yc|a(?>goya|tura|me|vy|b|)|c|e(?>ustar|c|t(?>bank|flix|work|)|w(?>s|)|x(?>us|t(?>direct|))|)|f(?>l|)|g(?>o|)|i(?>nja|ssa(?>n|y)|co|k(?>on|e)|)|l|o(?>kia|rt(?>hwesternmutual|on)|w(?>ruz|tv|)|)|p|r(?>a|w|)|u|z)|o(?>kinawa|ffice|saka|pen|oo|vh|b(?>server|i)|l(?>dnavy|ayan(?>group|)|lo)|m(?>ega|)|n(?>ion|e|g|l(?>ine|))|r(?>igins|a(?>cle|nge)|g(?>anic|))|t(?>suka|t))|p(?>ccw|ub|a(?>nasonic|ssagens|ge|r(?>is|s|t(?>ners|s|y))|y|)|e(?>t|)|f(?>izer|)|g|h(?>armacy|ilips|ysio|d|o(?>ne|to(?>graphy|s|))|)|i(?>oneer|zza|c(?>s|t(?>ures|et))|d|n(?>g|k|))|k|l(?>a(?>ce|y(?>station|))|u(?>mbing|s)|)|m|n(?>c|)|o(?>litie|ker|hl|rn|st)|r(?>ess|ime|a(?>merica|xi)|o(?>gressive|tection|pert(?>ies|y)|mo|d(?>uctions|)|f|)|u(?>dential|)|)|s|t|w(?>c|)|y)|q(?>pon|ue(?>bec|st)|a)|r(?>yukyu|a(?>cing|dio)|e(?>liance|cipes|xroth|view(?>s|)|hab|st(?>aurant|)|a(?>d|l(?>estate|t(?>or|y)))|d(?>umbrella|stone|)|i(?>se(?>n|)|t)|n(?>t(?>als|)|)|p(?>ublican|air|ort)|)|i(?>c(?>oh|h(?>ardli|))|l|o|p)|o(?>gers|deo|om|c(?>her|ks)|)|s(?>vp|)|u(?>gby|hr|n|)|w(?>e|))|s(?>fr|a(?>arland|kura|fe(?>ty|)|ms(?>club|ung)|rl|ve|xo|l(?>on|e)|n(?>dvik(?>coromant|)|ofi)|p|s|)|b(?>i|s|)|c(?>ience|ot|a|b|h(?>aeffler|midt|warz|ule|o(?>larships|ol))|)|d|e(?>rvices|lect|cur(?>ity|e)|ner|ven|ek|a(?>rch|t)|s|w|x(?>y|)|)|g|h(?>ell|a(?>ngrila|rp|w)|i(?>ksha|a)|o(?>uji|es|p(?>ping|)|w(?>time|))|)|i(?>lk|te|n(?>gles|a)|)|j|k(?>i(?>n|)|y(?>pe|)|)|l(?>ing|)|m(?>art|ile|)|n(?>cf|)|o(?>ft(?>bank|ware)|hu|c(?>cer|ial)|l(?>utions|ar)|n(?>g|y)|y|)|p(?>a(?>ce|)|o(?>rt|t))|r(?>l|)|s|t(?>ream|yle|ud(?>io|y)|a(?>ples|da|te(?>bank|farm)|r)|c(?>group|)|o(?>ckholm|r(?>age|e))|)|u(?>zuki|cks|pp(?>ort|l(?>ies|y))|r(?>gery|f)|)|v|w(?>atch|iss)|x|y(?>stems|dney|)|z)|t(?>a(?>ipei|obao|rget|lk|b|t(?>too|a(?>motors|r))|x(?>i|))|c(?>i|)|d(?>k|)|e(?>masek|nnis|am|ch(?>nology|)|st|va|l)|f|g|h(?>eat(?>er|re)|d|)|i(?>ckets|ffany|enda|aa|ps|r(?>es|ol))|j(?>maxx|x|)|k(?>maxx|)|l|m(?>all|)|n|o(?>shiba|day|kyo|ols|ray|tal|urs|wn|p|y(?>ota|s)|)|r(?>ust|a(?>ining|vel(?>channel|ers(?>insurance|)|)|d(?>ing|e))|v|)|t|u(?>nes|shu|be|i)|v(?>s|)|w|z)|u(?>ol|ps|a|b(?>ank|s)|g|k|n(?>i(?>versity|com)|o)|s|y|z)|v(?>laanderen|a(?>cations|n(?>guard|a)|)|c|e(?>ntures|gas|r(?>mögensberat(?>ung|er)|sicherung|isign)|t|)|g|i(?>ajes|king|llas|rgin|deo|g|n|p|s(?>ion|a)|v(?>a|o)|)|n|o(?>yage|dka|l(?>kswagen|vo)|t(?>ing|e|o))|u(?>elos|))|w(?>hoswho|me|a(?>tch(?>es|)|ng(?>gou|)|l(?>mart|ter|es))|e(?>ather(?>channel|)|b(?>site|cam|er)|d(?>ding|)|i(?>bo|r))|f|i(?>lliamhill|en|ki|n(?>dows|ners|e|))|o(?>lterskluwer|odside|r(?>ld|k(?>s|))|w)|s|t(?>c|f))|x(?>finity|erox|box|xx|yz|i(?>huan|n))|y(?>un|a(?>maxun|chts|ndex|hoo)|e|o(?>dobashi|kohama|ga|u(?>tube|))|t)|z(?>uerich|ero|one|ip|a(?>ppos|ra|)|m|w)|ε(?>λ|υ)|б(?>ел|г)|к(?>атолик|ом)|м(?>кд|о(?>сква|н))|о(?>нлайн|рг)|р(?>ус|ф)|с(?>айт|рб)|ا(?>تصالات|بوظبي|رامكو|مارات|یران|ل(?>سعودية|بحرين|جزائر|عليان|اردن|مغرب))|ب(?>ھارت|يتك|ا(?>زار|رت))|ع(?>مان|ر(?>اق|ب))|ك(?>اثوليك|وم)|م(?>ليسيا|صر|و(?>ريتانيا|قع))|இ(?>ந்தியா|லங்கை)|中(?>文网|信|国|國)|公(?>司|益)|台(?>湾|灣)|商(?>城|店|标)|政(?>务|府)|新(?>加坡|闻)|网(?>址|店|站|络)|香(?>格里拉|港)|닷(?>넷|컴))', 1, 65534))
3
Today at 16:30
geminiman
ip removed
4376c5301f7d111108731ecb14b8feac
https://www.satbox.info/index.php?action=post2;start=0;board=211
/home3/boxkings/public_html/Sources/Subs-Attachments.php (Line 781)
Backtrace information

Type of error: Database
Error message Select
Database Error: Field 'expire_date' doesn't have a default value


         INSERT INTO boxkingssatellite_attachments(`id_folder`, `id_msg`, `filename`, `file_hash`, `fileext`, `size`, `width`, `height`, `mime_type`, `approved`)
         VALUES
            (2, 0, SUBSTRING('Screenshot 2022-04-22 at 19-49-57 SMF 2.0 Settings Repair Tool.png', 1, 255), SUBSTRING('8ecc1a0969823aa33188498b9ed3204fc034b923', 1, 40), SUBSTRING('png', 1, , 20458, 1815, 212, SUBSTRING('image/png', 1, 20), 1)

2
Today at 16:30
geminiman
ip removed
4376c5301f7d111108731ecb14b8feac
https://www.satbox.info/index.php?action=uploadAttach;sa=add;c466da8=4376c5301f7d111108731ecb14b8feac
/home3/boxkings/public_html/Sources/Subs-Attachments.php (Line 781)
Backtrace information

Type of error: Database
Error message Select
Database Error: Field 'expire_date' doesn't have a default value


         INSERT INTO boxkingssatellite_attachments(`id_folder`, `id_msg`, `filename`, `file_hash`, `fileext`, `size`, `width`, `height`, `mime_type`, `approved`)
         VALUES
            (2, 0, SUBSTRING('Screenshot 2022-04-22 at 19-49-57 SMF 2.0 Settings Repair Tool.png', 1, 255), SUBSTRING('d31fce70f364c9779f83ab40a571da7aaa3cb305', 1, 40), SUBSTRING('png', 1, , 20458, 1815, 212, SUBSTRING('image/png', 1, 20), 1)

1
Today at 16:29
geminiman
ip removed
4376c5301f7d111108731ecb14b8feac
https://www.satbox.info/index.php?action=uploadAttach;sa=add;c466da8=4376c5301f7d111108731ecb14b8feac;board=211
/home3/boxkings/public_html/Sources/Subs-Attachments.php (Line 781)
Backtrace information

Type of error: Database
Error message Select
Database Error: Field 'expire_date' doesn't have a default value


         INSERT INTO boxkingssatellite_attachments(`id_folder`, `id_msg`, `filename`, `file_hash`, `fileext`, `size`, `width`, `height`, `mime_type`, `approved`)
         VALUES
            (2, 0, SUBSTRING('Screenshot 2022-04-22 at 19-49-57 SMF 2.0 Settings Repair Tool.png', 1, 255), SUBSTRING('b98dbb2bb0ebc06a971d2725038c2d5fc1fdaabf', 1, 40), SUBSTRING('png', 1, , 20458, 1815, 212, SUBSTRING('image/png', 1, 20), 1)

so i have re created what i have said happened . ok the character set has not changed at all now which is good . and i understand what you say THIS STUFF IS IN THE DATABASE and should not alter or return . but the expire date field most certainly does return . its done it again and every time . i have just seen it happen . i reiterate all databases are set to utf8 and ONLY ONE of them had the expire date field in it . that is the main database , and i said i have now dropped that field again for the third time .

so something is going on here that i can understand is making me look silly as i know and you are correct that field in the database should not return , but it does . i am at a loss to explain this .

i even used the fix packages tool to remove all hooks from all OLD uninstalled mods , it did . once i put the clean file set back in they all returned. there was an attachment expire date mod hook in the list i have gone back and just removed that hook now . and still the error and issue persists .

the database we are using as i said was restored by the host , they would only give us 3 dates to select from , two were after the problems we had and so of no use . and the other was i believe april 15 which was the only option open to us by the hosts and as far as my memory goes that was JUST before the problem . we never had any atttachemnt issues before upgrading smf versions . we had smf 2.0.15 and we upgraded to 2.0.19 if im correct . and i was advised to upgrade to the very lastest version which i did .only since then have these sort of issues and errors popped up .

and i can see the error saying incorrect string value but i assure you ALL databases are set to utf8 . so i have the correct character set yet smf is apparently saying I DONT . and smf is telling me the value in a field is incorrect when that field doesnt even exist . i bow to your knowledge every time doug , you are the expert and im nowhere near that . but i am telling you accurately what is occuring here . even if it is strange or impossible , its happening . so if its got you stumped and you are an expert well ive got no chance of working it out .

i gave kindred my host and site login details , if you want feel free to ask him for them in a pm and take a look for your self.

[geminiman]

in addition to getting an error message when i try and fail to attach a file i also get the following red bank of code as soon as i hit upload . (its looks to me like html code )

Code Select Expand

<!DOCTYPE html> <html lang="en-US"> <head> <meta charset="UTF-8"> <link rel="stylesheet" href="https://www.satbox.info/Themes/default/css/minified_8b19ec5d67139c41649d6bcef90b793e.css?smf212_1654436946"> <script> var smf_theme_url = "https://www.satbox.info/Themes/default"; var smf_default_theme_url = "https://www.satbox.info/Themes/default"; var smf_images_url = "https://www.satbox.info/Themes/default/images"; var smf_smileys_url = "https://www.satbox.info/Smileys"; var smf_smiley_sets = "default,classic,aaron,akyhne,tino,dizzy_light,BlueSmileyAnimation_2,bbph,sdboysmilies,dizzy_dark,fugue,alienine"; var smf_smiley_sets_default = "sdboysmilies"; var smf_avatars_url = "https://www.satbox.info/avatars"; var smf_scripturl = "https://www.satbox.info/index.php"; var smf_iso_case_folding = false; var smf_charset = "UTF-8"; var smf_session_id = "4376c5301f7d111108731ecb14b8feac"; var smf_session_var = "c466da8"; var smf_member_id = 3; var ajax_notification_text = 'Loading...'; var help_popup_heading_text = 'A little lost? Let me explain:'; var banned_text = 'Sorry piopat, you are banned from using this forum!'; var smf_txt_expand = 'Expand'; var smf_txt_shrink = 'Shrink'; var smf_quote_expand = false; var allow_xhjr_credentials = false; </script> <script src="https://ajax.googleapis.com/ajax/libs/jquery/3.6.0/jquery.min.js"></script> <script src="https://www.satbox.info/Themes/default/scripts/minified_d9b9cd394160d7b99a1e85c3d3b7bfa6.js?smf212_1654436946"></script> <script> var new_alert_title = "satellite box info"; var alert_timeout = 10000; var smf_you_sure ='Are you sure you want to do this?'; </script> <title>Database Error</title> <meta name="viewport" content="width=device-width, initial-scale=1"> <meta property="og:site_name" content="satellite box info"> <meta property="og:title" content="Database Error"> <meta property="og:description" content="Database Error"> <meta name="description" content="Database Error"> <meta name="theme-color" content="#557EA0"> <meta name="robots" content="noindex"> <link rel="help" href="https://www.satbox.info/index.php?action=help"> <link rel="contents" href="https://www.satbox.info/index.php"> <link rel="search" href="https://www.satbox.info/index.php?action=search"> <link rel="alternate" type="application/rss+xml" title="satellite box info - RSS" href="https://www.satbox.info/index.php?action=.xml;type=rss2;board=441"> <link rel="alternate" type="application/atom+xml" title="satellite box info - Atom" href="https://www.satbox.info/index.php?action=.xml;type=atom;board=441"> <link rel="index" href="https://www.satbox.info/index.php?board=441.0"> </head> <body id="firefox" class="action_uploadAttach board_441"> <div id="footerfix"> <div id="top_section"> <div class="inner_wrap"> <ul class="floatleft" id="top_info"> <li> <a href="https://www.satbox.info/index.php?action=profile" id="profile_menu_top" onclick="return false;"><img class="avatar" src="https://www.satbox.info/useravatars/avatar_3.png" alt=""><span class="textmenu">piopat</span></a> <div id="profile_menu" class="top_menu"></div> </li> <li> <a href="https://www.satbox.info/index.php?action=pm" id="pm_menu_top"> <span class="main_icons inbox"></span> <span class="textmenu">My Messages</span> </a> <div id="pm_menu" class="top_menu scrollable"></div> </li> <li> <a href="https://www.satbox.info/index.php?action=profile;area=showalerts;u=3" id="alerts_menu_top"> <span class="main_icons alerts"></span> <span class="textmenu">Alerts</span> <span class="amt">1</span> </a> <div id="alerts_menu" class="top_menu scrollable"></div> </li> <li id="nojs_logout"> <a href="https://www.satbox.info/index.php?action=logout;c466da8=4376c5301f7d111108731ecb14b8feac">Log out</a> <script>document.getElementById("nojs_logout").style.display = "none";</script> </li> </ul> <form id="search_form" class="floatright" action="https://www.satbox.info/index.php?action=search2" method="post" accept-charset="UTF-8"> <input type="search" name="search" value="">&nbsp; <select name="search_selection"> <option value="all">Entire forum </option> <option value="board" selected>This board</option> <option value="members">Members </option> </select> <input type="hidden" name="sd_brd" value="441"> <input type="submit" name="search2" value="Search" class="button"> <input type="hidden" name="advanced" value="0"> </form> </div><!-- .inner_wrap --> </div><!-- #top_section --> <div id="header"> <h1 class="forumtitle"> <a id="top" href="https://www.satbox.info/index.php"><img src="https://www.satbox.info/Satbox.Info_Genera_big.gif" alt="satellite box info"></a> </h1> <div id="siteslogan">FRIENDLY FORUM WITH MEMBERS WILLING TO HELP</div> </div> <div id="wrapper"> <div id="upper_section"> <div id="inner_section"> <div id="inner_wrap"> <div class="user"> <time datetime="2022-06-09T16:09:39Z">2022-06-09 17:09</time> <ul class="unread_links"> <li> <a href="https://www.satbox.info/index.php?action=unread" title="Show unread posts since last visit.">Unread Posts</a> </li> <li> <a href="https://www.satbox.info/index.php?action=unreadreplies" title="Show new replies to your posts.">Updated Topics</a> </li> </ul> </div> </div> <a class="mobile_user_menu"> <span class="menu_icon"></span> <span class="text_menu">Main Menu</span> </a> <div id="main_menu"> <div id="mobile_user_menu" class="popup_container"> <div class="popup_window description"> <div class="popup_heading">Main Menu <a href="javascript:void(0);" class="main_icons hide_popup"></a> </div> <ul class="dropmenu menu_nav"> <li class="button_home"> <a class="active" href="https://www.satbox.info/index.php"> <span class="main_icons home"></span><span class="textmenu">Home</span> </a> </li> <li class="button_search"> <a href="https://www.satbox.info/index.php?action=search"> <span class="main_icons search"></span><span class="textmenu">Search</span> </a> </li> <li class="button_admin subsections"> <a href="https://www.satbox.info/index.php?action=admin"> <span class="main_icons admin"></span><span class="textmenu">Admin <span class="amt">14</span></span> </a> <ul> <li> <a href="https://www.satbox.info/index.php?action=admin;area=featuresettings"> Features and Options </a> </li> <li> <a href="https://www.satbox.info/index.php?action=admin;area=packages"> Package Manager </a> </li> <li> <a href="https://www.satbox.info/index.php?action=admin;area=logs;sa=errorlog;desc"> Error Log <span class="amt">10</span> </a> </li> <li> <a href="https://www.satbox.info/index.php?action=admin;area=permissions"> Permissions </a> </li> <li> <a href="https://www.satbox.info/index.php?action=admin;area=viewmembers;sa=browse;type=approve"> Member Approvals <span class="amt">4</span> </a> </li> </ul> </li> <li class="button_moderate subsections"> <a href="https://www.satbox.info/index.php?action=moderate"> <span class="main_icons moderate"></span><span class="textmenu">Moderate</span> </a> <ul> <li> <a href="https://www.satbox.info/index.php?action=moderate;area=modlog"> Moderation Log </a> </li> <li> <a href="https://www.satbox.info/index.php?action=moderate;area=postmod;sa=posts"> Unapproved Posts and Topics </a> </li> <li> <a href="https://www.satbox.info/index.php?action=moderate;area=attachmod;sa=attachments"> Unapproved Attachments </a> </li> <li> <a href="https://www.satbox.info/index.php?action=moderate;area=reportedposts"> Reported Posts </a> </li> <li> <a href="https://www.satbox.info/index.php?action=moderate;area=reportedmembers"> Reported Members </a> </li> </ul> </li> <li class="button_calendar subsections"> <a href="https://www.satbox.info/index.php?action=calendar"> <span class="main_icons calendar"></span><span class="textmenu">Calendar</span> </a> <ul> <li> <a href="https://www.satbox.info/index.php?action=calendar"> View Calendar </a> </li> <li> <a href="https://www.satbox.info/index.php?action=calendar;sa=post"> Post Event </a> </li> </ul> </li> <li class="button_mlist subsections"> <a href="https://www.satbox.info/index.php?action=mlist"> <span class="main_icons mlist"></span><span class="textmenu">Members</span> </a> <ul> <li> <a href="https://www.satbox.info/index.php?action=mlist"> View the memberlist </a> </li> <li> <a href="https://www.satbox.info/index.php?action=mlist;sa=search"> Search for Members </a> </li> </ul> </li> </ul><!-- .menu_nav --> </div> </div> </div> <div class="navigate_section"> <ul> <li> <a href="https://www.satbox.info/index.php"><span>satellite box info</span></a> </li> <li> <span class="dividers"> &#9658; </span> <a href="https://www.satbox.info/index.php#c86"><span>SATBOX controversy BOARD</span></a> </li> <li class="last"> <span class="dividers"> &#9658; </span> <a href="https://www.satbox.info/index.php?board=441.0"><span>RANT ROOM </span></a> </li> </ul> </div><!-- .navigate_section --> </div><!-- #inner_section --> </div><!-- #upper_section --> <div id="content_section"> <div id="main_content_section"> <div id="fatal_error"> <div class="cat_bar"> <h3 class="catbg"> Database Error </h3> </div> <div class="windowbg"> <div class="padding"> Field 'expire_date' doesn't have a default value<br>File: /home3/boxkings/public_html/Sources/Subs-Attachments.php<br>Line: 781 </div> </div> </div> <div class="centertext"> <a class="button floatnone" href="javascript:document.location=document.referrer">Back</a> </div> </div><!-- #main_content_section --> </div><!-- #content_section --> </div><!-- #wrapper --> </div><!-- #footerfix --> <div id="footer"> <div class="inner_wrap"> <ul> <li class="floatright"><a href="https://www.satbox.info/index.php?action=help">Help</a> | <a href="https://www.satbox.info/index.php?action=agreement">Terms and Rules</a> | <a href="#top_section">Go Up &#9650;</a></li> <li class="copyright"><a href="https://www.satbox.info/index.php?action=credits" title="License" target="_blank" rel="noopener">SMF 2.1.2 &copy; 2022</a>, <a href="https://www.simplemachines.org" title="Simple Machines" target="_blank" rel="noopener">Simple Machines</a></li> </ul> </div> </div><!-- #footer --> <script> window.addEventListener("DOMContentLoaded", function() { function triggerCron() { $.get('https://www.satbox.info' + "/cron.php?ts=1654790970"); } window.setTimeout(triggerCron, 1); var user_menus = new smc_PopupMenu(); user_menus.add("profile", "https://www.satbox.info/index.php?action=profile;area=popup"); user_menus.add("alerts", "https://www.satbox.info/index.php?action=profile;area=alerts_popup;u=3"); user_menus.add("pm", "https://www.satbox.info/index.php?action=pm;sa=popup"); }); </script> </body> </html>

[Doug Heffernan]

i ran upgrade.php and again as it has done every single time it stopped at the point it is supposed to updated tables to utf8 , which is at about the 73% mark in the progress bar .

If you have upgraded your forum once, re-running the upgrader for the same version is not necessary. You should have mentioned this. The advice/suggestion was to simply overwrite the forum files. What happened when the upgrade stopped? Did it throw any errors at all? Are there any other additional errors logged in the server error log?

i went to my host and checked the databases , all of them show utf8 .so the character set did not change

When you perform an action on a forum/database, it has no affect what so over on other databases. They are separate things. Meaning working on a database will not change/touch/alter/modify or whatever the other databases.

Can you please answer this question?

Important: Besides the overwriting of the forum files, are you restoring a database backup as well from before the issues by any chance? Because that is the only reason that I can think of for the collation characters to be reverted and for the deleted database field to be re added back.

i gave kindred my host and site login details , if you want feel free to ask him for them in a pm and take a look for your self.

This will require indeed a thorough look directly at your forum and database to see how things are precisely and to sort it out. I do not have much free time right now for that. Hopefully someone else will look into this for you.

When/if you post a lengthy code in the future, can you please do so inside the code tags?

[geminiman]

"When/if you post a lengthy code in the future, can you please do so inside the code tags? " doug

sorry about that doug , my bad , never thought to do that .

"When you perform an action on a forum/database, it has no affect what so over on other databases. They are separate things. Meaning working on a database will not change/touch/alter/modify or whatever the other databases." doug

i understand that completely doug . the only reason i checked the other databases and did what i did was that you were telling me that you thought i must have set the character set to utf8 and dropped the expire date field on the wrong database . IE not the database related to my main site. i only did what i did to prove to you and to me also that i have indeed set the character collation to utf8 on the correct database and that i dropped (deleted ) the expire date field on the correct database . all databases are set to utf8 , so my point being HAD I for sake of argument set the collation to utf8 on the wrong database and hence the error kept coming up , that by virtue of setting all databases to utf8 that IF I DID INDEED change the character set on the wrong database as you seemed to think might be the case that by doing what i did removed all doubt , i made no error . if i did the error on the site would be gone . likewise the same applies to the expire date field . i did not drop it from the wrong database , it only exists (existed ) on one database , the database for the main site .


"If you have upgraded your forum once, re-running the upgrader for the same version is not necessary. You should have mentioned this. The advice/suggestion was to simply overwrite the forum files. What happened when the upgrade stopped? Did it throw any errors at all? Are there any other additional errors logged in the server error log?"doug


the errors in admin remain the same as posted above .

at the host in the error log the errors differ

Code Select Expand

[05-Jun-2022 12:07:08 America/Boise] PHP Warning:  Trying to access array offset on value of type null in /home3/boxkings/public_html/Sources/Load.php on line 105

[05-Jun-2022 18:07:31 Africa/Abidjan] PHP Parse error:  syntax error, unexpected identifier "year", expecting ")" in /home3/boxkings/public_html/Sources/Subs-Attachments.php on line 781

[06-Jun-2022 13:45:01 Africa/Abidjan] PHP Warning:  mysqli_stmt_bind_param() expects parameter 1 to be mysqli_stmt, bool given in /home3/boxkings/public_html/Sources/Subs-Db-mysql.php on line 1027
[06-Jun-2022 13:45:01 Africa/Abidjan] PHP Warning:  mysqli_stmt_bind_param() expects parameter 1 to be mysqli_stmt, bool given in /home3/boxkings/public_html/Sources/Subs-Db-mysql.php on line 1027
[06-Jun-2022 13:45:01 Africa/Abidjan] PHP Warning:  mysqli_stmt_execute() expects parameter 1 to be mysqli_stmt, bool given in /home3/boxkings/public_html/Sources/Subs-Db-mysql.php on line 1028
[06-Jun-2022 13:45:01 Africa/Abidjan] PHP Warning:  mysqli_stmt_execute() expects parameter 1 to be mysqli_stmt, bool given in /home3/boxkings/public_html/Sources/Subs-Db-mysql.php on line 1028
[06-Jun-2022 13:45:01 Africa/Abidjan] PHP Warning:  mysqli_stmt_bind_param() expects parameter 1 to be mysqli_stmt, bool given in /home3/boxkings/public_html/Sources/Subs-Db-mysql.php on line 1027
[06-Jun-2022 13:45:01 Africa/Abidjan] PHP Warning:  mysqli_stmt_bind_param() expects parameter 1 to be mysqli_stmt, bool given in /home3/boxkings/public_html/Sources/Subs-Db-mysql.php on line 1027
[06-Jun-2022 13:45:01 Africa/Abidjan] PHP Warning:  mysqli_stmt_execute() expects parameter 1 to be mysqli_stmt, bool given in /home3/boxkings/public_html/Sources/Subs-Db-mysql.php on line 1028
[06-Jun-2022 13:45:01 Africa/Abidjan] PHP Warning:  mysqli_stmt_execute() expects parameter 1 to be mysqli_stmt, bool given in /home3/boxkings/public_html/Sources/Subs-Db-mysql.php on line 1028


[08-Jun-2022 20:00:53 Africa/Abidjan] PHP Warning:  Parameter 1 to __lambda_func() expected to be a reference, value given in /home3/boxkings/public_html/Sources/Subs-List.php on line 164
[08-Jun-2022 20:00:53 Africa/Abidjan] PHP Warning:  Parameter 1 to __lambda_func() expected to be a reference, value given in /home3/boxkings/public_html/Sources/Subs-List.php on line 164
and for today

Code Select Expand

[09-Jun-2022 14:49:20 Africa/Abidjan] PHP Warning:  Parameter 1 to __lambda_func() expected to be a reference, value given in /home3/boxkings/public_html/Sources/Subs-List.php on line 164
[09-Jun-2022 14:56:56 Africa/Abidjan] PHP Fatal error:  Uncaught Error: Call to undefined function Shoutbox_Load() in /home3/boxkings/public_html/index.php:192
Stack trace:
#0 {main}
  thrown in /home3/boxkings/public_html/index.php on line 192
[09-Jun-2022 14:57:11 Africa/Abidjan] PHP Fatal error:  Uncaught Error: Call to undefined function Shoutbox_Load() in /home3/boxkings/public_html/index.php:192
Stack trace:
#0 {main}

[09-Jun-2022 09:09:02 America/Boise] PHP Notice:  Undefined index: name in /home3/boxkings/public_html/repair_settings.php on line 644
[09-Jun-2022 09:09:02 America/Boise] PHP Notice:  Undefined index: name in /home3/boxkings/public_html/repair_settings.php on line 645
[09-Jun-2022 09:09:02 America/Boise] PHP Notice:  Undefined index: name in /home3/boxkings/public_html/repair_settings.php on line 646

[09-Jun-2022 15:19:57 Africa/Abidjan] PHP Warning:  Parameter 1 to __lambda_func() expected to be a reference, value given in /home3/boxkings/public_html/Sources/Subs-List.php on line 164

those are the errors in error log from the 5th may to 9th may today . obviously they are repeated a lot in the log .

i thought i had to run the upgrader each time , that was what i thought was said in a post . i must have misread , my apologies for that . but that said even on the very first time running it and on later running it to upgrade to a newer version of smf the upgrader still stopped at 73%

"Can you please answer this question?

    Quote from: Doug Heffernan on Today at 11:23:46 AM
    Important: Besides the overwriting of the forum files, are you restoring a database backup as well from before the issues by any chance? Because that is the only reason that I can think of for the collation characters to be reverted and for the deleted database field to be re added back." doug

im not 100% sure that im understanding you on this doug . i have not personally restored any database , nor has any other admin on my site . the current database being used was restored by my host in late april i believe , when we had the initial problem . it was a database if memory serves from april 15th . this was the only database they could give me or would give me that was of any use , meaning they gave me just 4 restore dates , the 15th april , and all the other 3 were definately after the original problem occured . i believe the 15th april was just before the problem occurred , but im not 100% certain of that as the original problem may have been there at that time unknown to me .but as i say that is the only working option the host offered me . im sorry if im not understanding your question . and thanks again .

[Doug Heffernan]

sorry about that doug , my bad , never thought to do that .

You still posted the code without using the code tags. I had to edit your post again.

That said, can you post here the structure of your smf_log_errors table? What is your php version set to?

Code Select Expand

[09-Jun-2022 14:49:20 Africa/Abidjan] PHP Warning:  Parameter 1 to __lambda_func() expected to be a reference, value given in /home3/boxkings/public_html/Sources/Subs-List.php on line 164
[09-Jun-2022 14:56:56 Africa/Abidjan] PHP Fatal error:  Uncaught Error: Call to undefined function Shoutbox_Load() in /home3/boxkings/public_html/index.php:192
Stack trace:
#0 {main}
  thrown in /home3/boxkings/public_html/index.php on line 192
[09-Jun-2022 14:57:11 Africa/Abidjan] PHP Fatal error:  Uncaught Error: Call to undefined function Shoutbox_Load() in /home3/boxkings/public_html/index.php:192
Stack trace:
#0 {main}

[09-Jun-2022 09:09:02 America/Boise] PHP Notice:  Undefined index: name in /home3/boxkings/public_html/repair_settings.php on line 644
[09-Jun-2022 09:09:02 America/Boise] PHP Notice:  Undefined index: name in /home3/boxkings/public_html/repair_settings.php on line 645
[09-Jun-2022 09:09:02 America/Boise] PHP Notice:  Undefined index: name in /home3/boxkings/public_html/repair_settings.php on line 646

[09-Jun-2022 15:19:57 Africa/Abidjan] PHP Warning:  Parameter 1 to __lambda_func() expected to be a reference, value given in /home3/boxkings/public_html/Sources/Subs-List.php on line 164
those are the errors in error log from the 5th may to 9th may today . obviously they are repeated a lot in the log .

All these errors come from the shoutbox mod. Looking at this topic, you have errors all over the place caused by third party mods. And 2 of them are not even listed as installed at your forum, as per your posts.

i thought i had to run the upgrader each time , that was what i thought was said in a post . i must have misread , my apologies for that .

No problem. Whenever you are not sure about something, you can always ask. And something else if I may, be as detailed as possible when describing the things that you have done/the steps that you have taken. That saves quite a lot of time and it helps a lot. 

Anyways, as I mention above, this will require a through look directly at your forum and database imo. 

[geminiman]

"That said, can you post here the structure of your smf_log_errors table? What is your php version set to?" doug

i have attached a screenshot of the log error table to this post

"All these errors come from the shoutbox mod. Looking at this topic, you have errors all over the place caused by third party mods. And 2 of them are not even listed as installed at your forum, as per your posts." doug

as i type this we have just one mod installed , and that is shoutbox pro . we only have the default core theme installed , and nothing else . and just prior to installing shoutbox i had put in the clean file set .and i have instructed the other admin not to install anything else until further notice .

regarding php version i had spent a lot of time reading up , and i found a post saying that php 7.4 for what ever reason unknown to me throws up one of the errors that i have been getting . the advice given was that reverting back to php 7.3 may stop the errors , all be it probably not permanently . i do understand that php 7.3 is now deprecated . but some days back i decided to revert back to php 7.3 to see if the errors stopped . however now i have set the main site back to php 7.4 , i say this as you told me to mention anything i had done , so that is why i mention it .

"All these errors come from the shoutbox mod. Looking at this topic, you have errors all over the place caused by third party mods. And 2 of them are not even listed as installed at your forum, as per your posts." doug

do you mean my current shoutbox pro mod or some old long uninstalled shoutbox mod ? . thanks again for your time doug .

[mightygiants]

After upgrading to 2.1.2 I am getting a database error if I copy and past a picture into a post


Database Error
Incorrect string value: '\xE2\xAC\x9B\xE2\xAC\x9B...' for column 'body' at row 1
File: /home1/giantsfa/public_html/message_board/Sources/Subs-Post.php
Line: 1896

[geminiman]

ok sorry i tried to edit my last post to add info but i got a message saying i cant modify it at this time or similar . so i have to make a second post here .

i am adding two screenshots to this post .

so i ran the fix packages tool again to see what mods it listed as installed or uninstalled . i only had and only have one mod installed and that is shoutbox pro . but anyway fix packages listed two mods as installed , shoutbox pro and expire attachments . expire attachments is the mod causing me most trouble as it is stopping me attaching any files .

so i used fix packages tool to select expire attachment and list it as uninstalled . so its now not listed as installed , but its listed as uninstalled . please see the two attachments below . so the expire mod is definately still lingering . its now listed as uninstalled but i still cant attach any files , i tried .so ive learned a bit again today , always a good thing . but i still have to find a way to get rid of this and other unwanted mods . i did try selecting expire attachments in the uninstalled list and then selecting remove hook . to no avail , all that did was make the mods re appear in the installed list lol . so i just wanted to post this info .

[geminiman]

After upgrading to 2.1.2 I am getting a database error if I copy and past a picture into a post


Database Error
Incorrect string value: '\xE2\xAC\x9B\xE2\xAC\x9B...' for column 'body' at row 1
File: /home1/giantsfa/public_html/message_board/Sources/Subs-Post.php
Line: 1896

hi doug or kindred would be the best people to help you out , vastly experienced and knowledgeable on all things smf . but the error you are having is atleast in part related to your sites character set , if you are using smf 2.1.2 the character set needs to be utf8 for all your database tables . do you know how to access your host c panel ? (c panel is short for control panel ) . how you do that can vary a bit with different hosts . when i log into my host , i go to my c panel , in my c panel there are several segments each with multiple options that i can select .

FILES
SOFTWARE
ADVANCED
DATABASES

BEFORE I GO ANY FURTHER , IT IS ALWAYS BEST PRACTICE BEFORE MESSING WITH YOUR SITES DATABASE TO FIRST TAKE A BACKUP COPY OF THE DATABASE .

so i select DATABASES . then i select PHPMYADMIN . when that opens along the top of my screen from left to right i get options

DATABASES
SQL
STATUS and more

so then i select DATABASES , that will show you any databases that you have. if you only have one site and only one database stored on your host well then only one should be listed . if that is the case double click on that database and it should open and show you all tables in it .if you have more than one database well you will have to select the correct one .

now with all your database tables listed on your screen look along the top of your screen , again you should see multiple options , one should be OPERATIONS . if so open operations .

scroll down the page and you will see COLLATION . and below that it in a drop down box it should show what character set your site is currently set to . if it does not show UTF8 then you have to expand (open ) the drop down box and scroll down the list until you come to the UTF8 segment . my site is set to UTF8_GENERAL_CI

that is the option i recommend you select UNLESS DOUG OR KINDRED OR SOMEONE FAR MORE EXPERIENCED HERE ADVISES YOU OTHERWISE . my advice if you have ANY DOUBT OR CONCERN about anything smf wise is always err on the side of taking advice ONLY from a person of experience such as those i mention just above .

so if you are happy at this point to carry on and if doug etc are in agreement with what ive just posted here scroll down to and select UTF8_GENERAL_CI . once you have selected that you should notice that the character set has now changed from what it was before to utf8 . but you are not finished yet . just below where it says utf8 is a tick box saying

CHANGE ALL TABLES COLLATIONS

so put a tick on that , when you do that a second option will appear

CHANGE ALL TABLE COLUMNS COLLATIONS

tick that box also . now along the bottom of your screen towards the right you should see GO , select that .

YOUR DATABASE SHOULD NOW BE SET TO UTF8 CHARACTER SET . i have attached a screen shot at the bottom of this post here just to show you what the final part of my instruction above should look like .

just to add that credit for the above goes to doug who has already helped me with this .

[mightygiants]

After upgrading to 2.1.2 I am getting a database error if I copy and past a picture into a post


Database Error
Incorrect string value: '\xE2\xAC\x9B\xE2\xAC\x9B...' for column 'body' at row 1
File: /home1/giantsfa/public_html/message_board/Sources/Subs-Post.php
Line: 1896

hi doug or kindred would be the best people to help you out , vastly experienced and knowledgeable on all things smf . but the error you are having is atleast in part related to your sites character set , if you are using smf 2.1.2 the character set needs to be utf8 for all your database tables . do you know how to access your host c panel ? (c panel is short for control panel ) . how you do that can vary a bit with different hosts . when i log into my host , i go to my c panel , in my c panel there are several segments each with multiple options that i can select .

FILES
SOFTWARE
ADVANCED
DATABASES

BEFORE I GO ANY FURTHER , IT IS ALWAYS BEST PRACTICE BEFORE MESSING WITH YOUR SITES DATABASE TO FIRST TAKE A BACKUP COPY OF THE DATABASE .

so i select DATABASES . then i select PHPMYADMIN . when that opens along the top of my screen from left to right i get options

DATABASES
SQL
STATUS and more

so then i select DATABASES , that will show you any databases that you have. if you only have one site and only one database stored on your host well then only one should be listed . if that is the case double click on that database and it should open and show you all tables in it .if you have more than one database well you will have to select the correct one .

now with all your database tables listed on your screen look along the top of your screen , again you should see multiple options , one should be OPERATIONS . if so open operations .

scroll down the page and you will see COLLATION . and below that it in a drop down box it should show what character set your site is currently set to . if it does not show UTF8 then you have to expand (open ) the drop down box and scroll down the list until you come to the UTF8 segment . my site is set to UTF8_GENERAL_CI

that is the option i recommend you select UNLESS DOUG OR KINDRED OR SOMEONE FAR MORE EXPERIENCED HERE ADVISES YOU OTHERWISE . my advice if you have ANY DOUBT OR CONCERN about anything smf wise is always err on the side of taking advice ONLY from a person of experience such as those i mention just above .

so if you are happy at this point to carry on and if doug etc are in agreement with what ive just posted here scroll down to and select UTF8_GENERAL_CI . once you have selected that you should notice that the character set has now changed from what it was before to utf8 . but you are not finished yet . just below where it says utf8 is a tick box saying

CHANGE ALL TABLES COLLATIONS

so put a tick on that , when you do that a second option will appear

CHANGE ALL TABLE COLUMNS COLLATIONS

tick that box also . now along the bottom of your screen towards the right you should see GO , select that .

YOUR DATABASE SHOULD NOW BE SET TO UTF8 CHARACTER SET . i have attached a screen shot at the bottom of this post here just to show you what the final part of my instruction above should look like .

just to add that credit for the above goes to doug who has already helped me with this .

I just did as instructed.  It didn't crash the site, I will let you know if that resolved all the database errors.

[mightygiants]

So far, so good.  Not only did the collation operation stop the DB errors, but there were a variety of Chron errors that stopped showing up in my error logs

[geminiman]

im glad to hear that resolved your issues . my own are not resolved as yet even tho i have done the above . but it seems my forum issues are database related . so i am hoping one of the experts here can at some point take a look at it for me . but i am glad you got your forum fixed .

[Kindred]

geminiman, if you pm me access to your hosting account and set my account to temp admin again,  I'll take a look at your databases.

(Probably tomorrow, realistically)

[geminiman]

hi kindred and thank you . i think i already sent you a pm with my site and host login info , do you still have it or did you delete it ? would have been i think later april if memory serves , but you help so many people and i assume get so many pms that your inbox will be quite full . probably be a long list to go through .so i will happily send it to you again . pm on the way kindred , please feel free to do as you feel necessary on the site or host , you have my full consent . my host takes backups and i have a backup app in place on the host also so dont worry . and thank you again , you have helped me a lot over the time ive been a member here .

EDIT :

two PMs sent kindred , i forgot to include some info in the first one . thank you , when ever you get some free time is fine , no rush .