Alex94

Even then, I'm not sure where I could have a more recent version of mysql. All I see I can change is the php. <.< You want access to the dashboard from the host? You would need to sign into my google+ , if that's ok with you.

It did not fix it Getting the same error: IPS\Db\Exception: Prepared statement needs to be re-prepared (1615) Also I meant completely starting over as if I was brand new. New database, new forums, new everything. We didn't have this issue on the old server, just after we transferred to a new server and according to them, every server is configured the same.

Oh I went back to phpMyAdmin and it successfully transferred the files from the old database to the new one. What's the next step? I'm assuming I edit the fields of conf_global.php: 'sql_database' => 'xxxxxxxxxxx', 'sql_user' => 'xxxxxxxxx', 'sql_pass' => 'xxxxxxxxx', To match the name of the new user and the new database?

Fix the user how? When I click User Manager / manage user authentication and privileges in HeidiSQL, The error is: SQL Error (1227): Access Denied; you need (at least one of) the RELOAD privileges for this operation. If we don't fix this, I'm starting to think of just deleting everything and start fresh with new forums. We been using the forums since March, so not a lot would be lost. but then again the learning experience can be quite useful

If I try to export it into the other database directly, I get this error: Access denied for user 'databaseXXX'@'X.X.X.X' to database 'databaseXXX'. If I try export it into a ZIP .sql file, I get this error: Cannot create file "C:\Program Files\HeidiSQL\[Same as on source server]_temp.sql". Access is denied

Every time I try to import, it keeps saying no database selected. Do you know the correct syntax? I tried using DROP XXX ,CREATE XXX, and USE XXX. Even tried just importing the way it was when I export it. Also I tried connected through HeidiSQL and even allowed my IP, but it still says Host X.X.X.X is now allowed to connect to this MariaDB server EDIT: Good news, I'm finally inside of HeidiSQL

Just curious how long does importing take? Exporting was just a second, but uploading seems to be longer. Through phpMyAdmin, the upload is still at 0% with a counter clockwise circle on the web tab :/ Hopefully my google fiber kicks in some time soon.

Yea <.< just trying to make it work. lol Ok I just updated the htaccess and the error is still occurring. Originally the htacces was: <IfModule mod_rewrite.c> Options -MultiViews RewriteEngine On RewriteBase / RewriteCond %{REQUEST_FILENAME} !-f RewriteRule \.(js|css|jpeg|jpg|gif|png|ico|map)(\?|$) /404error.php [L,NC] RewriteCond %{REQUEST_FILENAME} !-f RewriteCond %{REQUEST_FILENAME} !-d RewriteRule . /index.php [L] </IfModule> <IfModule mod_security2.c> SecRuleRemoveById 340009 </IfModule> This is the only advice the host support is saying: "I can confirm this error is probably related to your laravel configuration."

Well putting it into the htaccess didn't help, just the same error. The message is: Sorry for just the image, the forums thought the error messages was spam. EDIT: sorry I forgot to make the changes live. Here's what it does when I put it into htaccess.

I have .htaccess. I do remember it came without it and without it, every sub-page will result in a "can't find webpage" error. So I wrote it. Should I include this into the htaccess? From this forums: https://laracasts.com/discuss/channels/laravel/general-error-1615-prepared-statement-needs-to-be-re-prepared-selecting-mysql-view?page=1

SELECT * FROM `core_widget_areas` WHERE app='forums' AND module='forums' AND controller='index' IPS\Db\Exception: Prepared statement needs to be re-prepared (1615) #0 /home/u580595389/public_html/system/Db/Select.php(356): IPS\_Db->preparedQuery('/*IPS\\Dispatche...', Array, true) #1 /home/u580595389/public_html/system/Db/Select.php(418): IPS\Db\_Select->runQuery() #2 /home/u580595389/public_html/system/Dispatcher/Front.php(427): IPS\Db\_Select->rewind() #3 /home/u580595389/public_html/system/Dispatcher/Dispatcher.php(131): IPS\Dispatcher\_Front->finish() #4 /home/u580595389/public_html/index.php(13): IPS\_Dispatcher->run() #5 {main} Basically each error always has the line: IPS\Db\Exception: Prepared statement needs to be re-prepared (1615) Here's another error: SELECT word_key, word_default, word_custom FROM `core_sys_lang_words` WHERE lang_id=1 AND word_key IN('__indefart_content_record_comments_title','__indefart_content_record_reviews_title','content_db_lang_ia_1','__defart_content_record_comments_title','__defart_content_record_reviews_title','content_db_lang_sl_1','content_db_lang_su_1','content_record_comment_title','content_record_review_title','content_record_comments_title','content_record_comments_title_lc','content_record_reviews_title','content_record_reviews_title_lc','content_db_lang_pu_1','content_db_lang_pl_1','content_field_1','content_field_2','forums','select_forum','start_new_topic','toggle_this_category','forums_forum_4','forums_forum_9','forums_forum_9_desc','posts_no_number','view_user_profile','byline_nodate','get_last_post','_date_this_year_short','_date_this_year_long','forums_forum_33','redirect_hits','forums_forum_33_desc','forums_forum_34','redirect_hits','forums_forum_34_desc','forums_forum_5','forums_forum_32','forums_forum_32_desc','posts_no_number','view_user_profile','byline_nodate','f_days_short','_date_this_week_c','forums_forum_10','forums_forum_10_desc','posts_no_number','view_user_profile','byline_nodate','f_hours_short','f_hours','_date_ago_c','forums_forum_11','forums_forum_11_desc','posts_no_number','view_user_profile','byline_nodate','f_days_short','_date_this_week_c','forums_forum_6','forums_forum_12','forums_forum_12_desc','posts_no_number','_date_this_year_short','_date_last_year_long','forums_forum_35','forums_forum_35_desc','posts_no_number','forums_forum_13','forums_forum_13_desc','posts_no_number','f_days_short','_date_this_week_c','forums_forum_7','forums_forum_14','forums_forum_14_desc','posts_no_number','_date_this_year_short','_date_this_year_long','forums_forum_15','forums_forum_27','forums_forum_28','forums_forum_29','forums_forum_15_desc','posts_no_number','f_minutes_short','f_minutes','_date_ago_c','forums_forum_16','forums_forum_45','forums_forum_44','forums_forum_16_desc','posts_no_number','view_user_profile','byline_nodate','f_minutes_short','f_minutes','_date_ago_c','forums_forum_17','forums_forum_24','forums_forum_19','forums_forum_23','forums_forum_20','forums_forum_22','forums_forum_17_desc','posts_no_number','view_user_profile','byline_nodate','f_hours_short','f_hours','_date_ago_c','forums_forum_25','forums_forum_26','forums_forum_25_desc','posts_no_number','view_user_profile','byline_nodate','_date_this_year_short','_date_this_year_long','forums_forum_30','forums_forum_47','forums_forum_30_desc','posts_no_number','f_days_short','_date_yesterday_c','forums_forum_8','forums_forum_31','forums_forum_43','forums_forum_36','forums_forum_40','forums_forum_42','forums_forum_41','forums_forum_46','forums_forum_39','forums_forum_37','forums_forum_38','forums_forum_31_desc','posts_no_number','_date_this_year_short','_date_this_year_long','jump_to_content_desc','jump_to_content','search_everything','advanced_search','search_placeholder','frontnavigation_forums','menu_item_54','form_form_4','form_form_7','form_form_5','menu_item_59','menu_item_33','menu_item_34','menu_item_35','menu_item_36','menu_item_38','menu_item_39','leaderboard_title','more','menu_content','view_my_profile','menu_profile','my_attachments','menu_settings_title','menu_followed_content','edit_account_settings','menu_settings','menu_manage_ignore','menu_modcp','menu_admincp','sign_out','create_menu_title','create_menu','add_announcement','announcement','topic','select_category','file_download','cms_select_category','cms_create_menu_records_1','gallery_image','select_calendar','event','form_submit','userbar_notifications','notification_options','notifications','see_all_notifications','userbar_messages','compose_new','message_sent','inbox','go_to_inbox','userbar_reports','report_center_header','report_center_link','stream_title_1','mark_site_read','mark_site_read_button','home','block_announcements','block_whosOnline','block_whos_online_info_members','block_whos_online_info_anonymous','block_whos_online_info_guests','see_full_list','block_Blocks','widget_title_27ba48f54c2ab62df982ededea0ab094','view_user_profile','replies_number','view_this_topic','byline_nodate','_date_this_week_c','topic_started_date','replies_number','view_this_topic','_date_this_week_c','topic_started_date','replies_number','view_this_topic','_date_this_year_short','_date_this_year_long','topic_started_date','view_user_profile','replies_number','view_this_topic','byline_nodate','_date_this_year_short','_date_this_year_long','topic_started_date','replies_number','view_this_topic','_date_this_week_c','topic_started_date','replies_number','featured','view_this_topic','_date_this_year_short','_date_this_year_long','topic_started_date','replies_number','view_this_topic','_date_this_week_c','topic_started_date') and word_js=0 IPS\Db\Exception: Prepared statement needs to be re-prepared (1615) #0 /home/u580595389/public_html/system/Db/Select.php(356): IPS\_Db->preparedQuery('/*IPS\\_Lang::pa...', Array, true) #1 /home/u580595389/public_html/system/Db/Select.php(418): IPS\Db\_Select->runQuery() #2 /home/u580595389/public_html/system/Lang/Lang.php(1446): IPS\Db\_Select->rewind() #3 /home/u580595389/public_html/system/Widget/Widget.php(754): IPS\_Lang->parseOutputForDisplay('\n\n\t<h3 class='i...') #4 /home/u580595389/public_html/system/Theme/Theme.php(780) : eval()'d code(13650): IPS\_Widget->__toString() #5 /home/u580595389/public_html/system/Theme/SandboxedTemplate.php(57): IPS\Theme\class_core_front_global->widgetContainer('sidebar', 'vertical') #6 /home/u580595389/public_html/system/Theme/Theme.php(780) : eval()'d code(11342): IPS\Theme\_SandboxedTemplate->__call('widgetContainer', Array) #7 /home/u580595389/public_html/system/Theme/SandboxedTemplate.php(57): IPS\Theme\class_core_front_global->sidebar('right') #8 /home/u580595389/public_html/system/Theme/Theme.php(780) : eval()'d code(5216): IPS\Theme\_SandboxedTemplate->__call('sidebar', Array) #9 /home/u580595389/public_html/system/Theme/SandboxedTemplate.php(57): IPS\Theme\class_core_front_global->globalTemplate('98ec2b7ca8b1dce...', '\n\n\n<div class='...', Array) #10 /home/u580595389/public_html/system/Dispatcher/Dispatcher.php(149): IPS\Theme\_SandboxedTemplate->__call('globalTemplate', Array) #11 /home/u580595389/public_html/system/Dispatcher/Standard.php(104): IPS\_Dispatcher->finish() #12 /home/u580595389/public_html/system/Dispatcher/Front.php(524): IPS\Dispatcher\_Standard->finish() #13 /home/u580595389/public_html/system/Dispatcher/Dispatcher.php(131): IPS\Dispatcher\_Front->finish() #14 /home/u580595389/public_html/index.php(13): IPS\_Dispatcher->run() #15 {main}

Mhm alright, last time I talked to them about it, they kinda just gave me google results so not really that helpful. But thank you! I'll let them know!

Error 1615 So lately the server has been slow and had heavy traffic, so I asked my provider to move to a new server. Ever since the transition to the new server, I been getting the following SQL error: IPS\Db\Exception: Prepared statement needs to be re-prepared (1615) I thought updating to the latest IPB software could help but the error is still there.