View Single Post
  #2075  
Old 03-10-2020, 06:47 PM
shka shka is offline
 
Join Date: Mar 2016
Posts: 79
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

It is only a MariaDB-reserved-word-problem with two possible reasons and solutions.

A. Install mod first and later upgrade MariaDB to 10.2.4+
Then you can check in phpmyadmin if there is a column "rows" in table formbits. If yes then backticks two posts above is the solution.
If no then B.

B. (like PPhysX) Install mod on MariaDB 10.2.4+
Then adding the "rows"-column fails in installer. Then it makes more sense to use a better column-name.
a. First goto phpmyadmin in forum-db
Call sql (same as installer but changed column to "textrows" for visible rows in textarea)
Code:
ALTER TABLE formbits ADD textrows int(5) NOT NULL default '3';
Then with sql "show fields from formbits" you shoud see a new line (= tablecolumn) called textrows

b. The go to forms.php and edit the three lines 1976,3305,3555. You can use old or new version (with or without backticks, but replace "rows" with "textrows").

c. Then edit some other lines (always replacing rows with textrows shown next)
Code:
line 2054
			textrows = '". $vbulletin->db->escape_string($rows)."',
line 3401
			'rows'          => $formbit['textrows'],
line 475
			$formoutput .= $form['prea'] . ($qo[$formbit[id]] >= $formbit['textrows']  ...
line 521
		elseif (($qo[$formbit[id]] < $formbit['textrows'] OR ...
line 1611
			$i = $formbit['textrows'];
line 2377
			$starti = $formbit['textrows'];
line 3314
					'" . $vbulletin->db->escape_string($question['textrows']) . "',
line 3564
					'" . $vbulletin->db->escape_string($question['textrows']) . "',
Reply With Quote
 
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01182 seconds
  • Memory Usage 1,766KB
  • Queries Executed 11 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD_SHOWPOST
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (2)bbcode_code
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_box
  • (1)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (1)post_thanks_postbit_info
  • (1)postbit
  • (1)postbit_onlinestatus
  • (1)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • reputationlevel
  • showthread
Included Files:
  • ./showpost.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_postinfo_query
  • fetch_postinfo
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showpost_start
  • bbcode_fetch_tags
  • bbcode_create
  • postbit_factory
  • showpost_post
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • showpost_complete