Split topic error

 
Douzeper
Benutzer
Avatar
Geschlecht:
Herkunft: Antrim, Northern Ireland
Alter: 55
Homepage: motorhomecraic.com
Beiträge: 555
Dabei seit: 10 / 2004
Betreff:

Split topic error

 · 
Gepostet: 18.08.2019 - 20:01 Uhr  ·  #1
Hi Chris,

Get the following error when trying to split a topic, I have done a database repair but it's still there. We moved servers recently so might have something to do with that.

Code
Error
256 — An error occured during the execution of the database query!
INSERT INTO cf934_topics ( `topic_forum_id`, `topic_icon`, `topic_verified`, `topic_reported`, `topic_conf_bday`, `topic_title`, `topic_poster`, `topic_created`, `topic_subtitle`, `topic_hits`, `topic_replies`, `topic_status`, `topic_type`, `topic_sticktime`, `topic_newsentry`, `topic_newsentry_time`, `topic_fst_poster`, `topic_fst_subject`, `topic_fst_poster_color`, `topic_fst_poster_id`, `topic_lst_poster_id`, `topic_lst_poster`, `topic_lst_poster_color`, `topic_lst_subject`, `topic_lst_viewed_time`, `topic_poll_active`, `topic_poll_maxtime`, `topic_poll_id`, `topic_rating`, `topic_pcasttype`, `topic_podcast`, `topic_last_post_time` ) VALUES ( 2, 0, 1, 0, 0, 'Hello all', 7555, 1566150895, '', 0, 2, 0, 0, 0, 0, 0, 'kwh', 'Hello all', '80BFFF', 7555, 7555, 'kwh', '80BFFF', 'Re: Motorhome Vehicle category', 1566150895, 0, 0, 0, 0, 0, 0, '1566150423' )


-----------------

I also get the following error with trying multi quote, this one has been since before the server change :/

Not Found
The requested URL /forum/undefined&quote=161731;161727 was not found on this server.

Additionally, a 404 Not Found error was encountered while trying to use an ErrorDocument to handle the request.
cback
Admin
Avatar
Geschlecht:
Herkunft: Saarland
Alter: 38
Homepage: cback.net
Beiträge: 17610
Dabei seit: 12 / 2003
Betreff:

Re: Split topic error

 · 
Gepostet: 19.08.2019 - 14:13 Uhr  ·  #2
Hi Ally!

The Multiquote one is easy, you can find a Fix for that here:
mehrfachzitierung-fehlermeldung-404-p162746.html#real162746

Just apply that Codechange and it should work again. :)


The second one should be a MySQL Strict Problem that was not discovered yet, I'll fix that in the next Version.
You can do that fix yourself now by going into your phpMyAdmin and open the forum Database.
Click on the Tab "SQL" and execute these two queries:

Code

ALTER TABLE `cf934_topics` CHANGE `topic_fst_post_id` `topic_fst_post_id` MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0';
ALTER TABLE `cf934_topics` CHANGE `topic_lst_post_id` `topic_lst_post_id` MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0';


I already used your correct table prefix from that error message.

This sould make the topic split work again. :)

Sincerely,
Chris
Douzeper
Benutzer
Avatar
Geschlecht:
Herkunft: Antrim, Northern Ireland
Alter: 55
Homepage: motorhomecraic.com
Beiträge: 555
Dabei seit: 10 / 2004
Betreff:

Re: Split topic error

 · 
Gepostet: 19.08.2019 - 14:28 Uhr  ·  #3
cback
Admin
Avatar
Geschlecht:
Herkunft: Saarland
Alter: 38
Homepage: cback.net
Beiträge: 17610
Dabei seit: 12 / 2003
Betreff:

Re: Split topic error

 · 
Gepostet: 19.08.2019 - 14:35 Uhr  ·  #4
Gewählte Zitate für Mehrfachzitierung:   0

Registrierte in diesem Topic

Aktuell kein registrierter in diesem Bereich

Die Statistik zeigt, wer in den letzten 5 Minuten online war. Erneuerung alle 90 Sekunden.