Bot postuje neexistujuce topiky

Forum rules
If you need support, please post the request in this format
[version] Description
Post Reply
Matonym
nováček
nováček
Posts: 2
Joined: 18.6.2014 22:28:40
SmiX .MODs user: Yes

Bot postuje neexistujuce topiky

Post by Matonym » 18.6.2014 23:03:46

Ahoj SmiX, tu Matonym z Runescape :)

Viem, že verziu neodporúčaš na Live fóra no túto funkcionalitu teraz potrebujeme pre náš Translačný team.

Toto je chyba, ktorú dostávam pri otvorení Index.php po zapnutí Feedu.
Spoiler: show

Code: Select all

General Error
SQL ERROR [ mysqli ]

Column 'post_profile' cannot be null [1048]

SQL

INSERT INTO phpbb_posts (forum_id, poster_id, icon_id, poster_ip, post_time, post_approved, enable_bbcode, enable_smilies, enable_magic_url, enable_sig, post_username, post_subject, post_text, post_checksum, post_attachment, bbcode_bitfield, bbcode_uid, post_postcount, post_edit_locked, post_profile, topic_id) VALUES ('436', 344, 0, '95.102.22.132', 1403124380, 1, 1, 1, 1, 1, '', 'Lorem ipsum 2014-06-18T20:38:00+00:00', 'Lorem ipsum 2014-06-18T20:38:00+00:00, Test, Labore exercitation consequat eu dolore in ullamco ut id irure dolore sint elit commodo., <!-- m --><a class=\"postlink\" href=\"http://example.com/test/1403123880\">http://example.com/test/1403123880</a><!-- m -->, RSS for Node, Wed, 18 Jun 2014 20:46:20 GMT, John Smith, Wed, 18 Jun 2014 20:38:00 GMT, Michael Bertolacci, licensed under a Creative Commons Attribution 3.0 Unported License., 60, <!-- m --><a class=\"postlink\" href=\"http://example.com/test/1403123880\">http://example.com/test/1403123880</a><!-- m -->', '3abf0a09e98bd787e87d29b193fa93e5', 0, '', '', 1, 0, NULL, 7346)

BACKTRACE

FILE: (not given by php)
LINE: (not given by php)
CALL: msg_handler()

FILE: [ROOT]/includes/db/dbal.php
LINE: 754
CALL: trigger_error()

FILE: [ROOT]/includes/db/mysqli.php
LINE: 182
CALL: dbal->sql_error()

FILE: [ROOT]/includes/functions_posting.php
LINE: 2004
CALL: dbal_mysqli->sql_query()

FILE: [ROOT]/includes/mods/sfnc/sfnc.class.php
LINE: 753
CALL: submit_post()

FILE: [ROOT]/includes/mods/sfnc/sfnc.class.php
LINE: 617
CALL: sfnc->init_posting()

FILE: [ROOT]/includes/mods/sfnc/sfnc.class.php
LINE: 802
CALL: sfnc->setup_posting()

FILE: [ROOT]/index.php
LINE: 56
CALL: sfnc->index_init()
Phpbb 3.0.11
nastavenia1.PNG
Feed Settings
Post Profile to posiela Null. V subfore kam sa to postovalo mi vznikli topiky, ktore ukazuju ze su od daneho autora ako je nastavene v setting no v zobrazeni subfora sa v stlpci last post zobrazuje Guest a divny datum. Topik sa neda otvorit - napise to, ze The requested topic does not exist.

Image

General configuration je podla tvojich odporucani - nie cez CRON.

Vies nam prosim pomoct? V pripade potreby sa mozeme dohodnut aj na accesse v minulosti si uz mal u nas na webe Founder status.

User avatar
Smix
admin
admin
Posts: 799
Joined: 16.2.2007 16:34:59
SmiX .MODs user: Yes
Location: 127.0.0.1
Contact:

Re: Bot postuje neexistujuce topiky

Post by Smix » 19.6.2014 16:30:22

Ahoj :-)
Konečně někdo, kdo ví, že když se hlásí chyba, že se musí přidat i error message :-) Díky! :D

... Krátké googlení ... https://www.phpbb.com/customise/db/mod/ ... iew_unread ... Pokusím se na to udělat asi v neděli čas a pročíst to důkladně ;-)

Tohle by mohl bejt docela zásadní fix, protože mi hromada lidí hlásila, že "to nejde", ale mě to (překvapivě) vždy fungovalo ... :oops:

Btw. ty posty neexistujou, resp. založili se, ale content se nevložil, proto nejdou otevřít ...
Since I´m @ work, I´m very busy ... If you like my work, please reconsider a small donation ;-)
Follow development on
github
@smixmods
Image

Matonym
nováček
nováček
Posts: 2
Joined: 18.6.2014 22:28:40
SmiX .MODs user: Yes

Re: Bot postuje neexistujuce topiky

Post by Matonym » 20.6.2014 00:42:54

Ahoj,

vďaka tvojmu googleniu som si to fixol sám :D

Problém bol presne v MODe Hide Profile in Viewtopic, ktory pridava ten extra udaj pri postovani new topiku post_profile. Jednoducho som ho pridal do tvojho sfnc.class.php (dvakrat, ale asi by stacilo raz) s pevnou hodnotou 0.

A už to funguje. Solved.

User avatar
Smix
admin
admin
Posts: 799
Joined: 16.2.2007 16:34:59
SmiX .MODs user: Yes
Location: 127.0.0.1
Contact:

Re: Bot postuje neexistujuce topiky

Post by Smix » 20.6.2014 08:55:43

... kdyžtak se tu

Code: Select all

poděl
;-)
Since I´m @ work, I´m very busy ... If you like my work, please reconsider a small donation ;-)
Follow development on
github
@smixmods
Image

Post Reply

Who is online

Users browsing this forum: No registered users and 1 guest