After installation ... General Error !!

Posted: Fri Jan 09, 2009 3:55 pm

I installed my raven and clicking around, I discovered a series of errors.

For example:

If I click on "Private Messages"
This page shows me this message

Could not query attachment information

DEBUG MODE

SQL Error : 1146 Table 'Sql62098_2.nuke_bbattachments_config' doesn't exist

SELECT * FROM nuke_bbattachments_config

Line : 91
File : attachment_mod.php

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

If I click on "ErrorDocuments"
This page shows me this message

ERROR:

An unknown error occurred.
Hint:

Refered From : http://www.sportsverona.com/html1/modules.php?name=Encyclopedia
Your IP : XXX.XX.XX.XXX
Page Requested : /html1/modules.php?name=ErrorDocuments
Agent : Mozilla/5.0 (Windows; U; Windows NT 5.1; it; rv:1.9.0.5) Gecko/2008120122 Firefox/3.0.5
Redirect Status : Unknown

-------------------------------
If I click on "Forum"
This page shows me this message

Could not query attachment information

DEBUG MODE

SQL Error : 1146 Table 'Sql62098_2.nuke_bbattachments_config' doesn't exist

SELECT * FROM nuke_bbattachments_config

Line : 91
File : attachment_mod.php

---------------------------------------------
If I click on "member list"
This page shows me this message

Could not query attachment information

DEBUG MODE

SQL Error : 1146 Table 'Sql62098_2.nuke_bbattachments_config' doesn't exist

SELECT * FROM nuke_bbattachments_config

Line : 91
File : attachment_mod.php

----------------------
someone help me please?

Posted: Fri Jan 09, 2009 4:12 pm

Either you didnt install the tables for the attachment mod, or the theme you are using doesn't have the attachment mod changes...

evaders99 wrote:

Since the Attachment Mod became integrated into RavenNuke, it lost the install.txt in the docs

I will copy the relevant instructions here. Please use and modify accordingly for your template

Code:




copy attachment_mod/templates/subSilver/add_attachment_body.tpl to templates/subSilver/add_attachment_body.tpl


copy attachment_mod/templates/subSilver/posted_attachments_body.tpl to templates/subSilver/posted_attachments_body.tpl


copy attachment_mod/templates/subSilver/posting_attach_body.tpl to templates/subSilver/posting_attach_body.tpl


copy attachment_mod/templates/subSilver/posting_attach_rules.tpl to templates/subSilver/posting_attach_rules.tpl


copy attachment_mod/templates/subSilver/uacp_body.tpl to templates/subSilver/uacp_body.tpl


copy attachment_mod/templates/subSilver/viewtopic_attach_body.tpl to templates/subSilver/viewtopic_attach_body.tpl


copy attachment_mod/templates/subSilver/admin/attach_cat_body.tpl to templates/subSilver/admin/attach_cat_body.tpl


copy attachment_mod/templates/subSilver/admin/attach_cp_attachments.tpl to templates/subSilver/admin/attach_cp_attachments.tpl


copy attachment_mod/templates/subSilver/admin/attach_cp_body.tpl to templates/subSilver/admin/attach_cp_body.tpl


copy attachment_mod/templates/subSilver/admin/attach_cp_search.tpl to templates/subSilver/admin/attach_cp_search.tpl


copy attachment_mod/templates/subSilver/admin/attach_cp_user.tpl to templates/subSilver/admin/attach_cp_user.tpl


copy attachment_mod/templates/subSilver/admin/attach_extension_groups.tpl to templates/subSilver/admin/attach_extension_groups.tpl


copy attachment_mod/templates/subSilver/admin/attach_extensions.tpl to templates/subSilver/admin/attach_extensions.tpl


copy attachment_mod/templates/subSilver/admin/attach_forbidden_extensions.tpl to templates/subSilver/admin/attach_forbidden_extensions.tpl


copy attachment_mod/templates/subSilver/admin/attach_manage_body.tpl to templates/subSilver/admin/attach_manage_body.tpl


copy attachment_mod/templates/subSilver/admin/attach_quota_body.tpl to templates/subSilver/admin/attach_quota_body.tpl


copy attachment_mod/templates/subSilver/admin/attach_shadow.tpl to templates/subSilver/admin/attach_shadow.tpl


copy attachment_mod/templates/subSilver/admin/extension_groups_permissions.tpl to templates/subSilver/admin/extension_groups_permissions.tpl














# 


#-----[ OPEN ]---------------------------------------------


# 


templates/subSilver/modcp_body.tpl





#


#-----[ FIND ]---------------------------------------------


# around line 27 


     <td class="row1">&nbsp;<span class="topictitle">{topicrow.TOPIC_TYPE}<a href="{topicrow.U_VIEW_TOPIC}" class="topictitle">{topicrow.TOPIC_TITLE}</a></span></td>





# 


#-----[ IN-LINE FIND ]---------------------------------------------


# around line 27 (directly in that line)


{topicrow.TOPIC_TYPE}





# 


#-----[ IN-LINE BEFORE, ADD ]---------------------------------------


# 


{topicrow.TOPIC_ATTACHMENT_IMG}





# 


#-----[ OPEN ]---------------------------------------------


# 


templates/subSilver/posting_body.tpl





# 


#-----[ FIND ]---------------------------------------------


# around line 258


<form action="{S_POST_ACTION}" method="post" name="post" onsubmit="return checkForm(this)">





# 


#-----[ REPLACE WITH ]---------------------------------------


# 


<form action="{S_POST_ACTION}" method="post" name="post" onsubmit="return checkForm(this)" {S_FORM_ENCTYPE}>





# 


#-----[ FIND ]---------------------------------------------


# around line 462


   {POLLBOX} 





# 


#-----[ BEFORE, ADD ]---------------------------------------


# 


   {ATTACHBOX}





# 


#-----[ OPEN ]---------------------------------------------


# 


templates/subSilver/posting_preview.tpl





# 


#-----[ FIND ]---------------------------------------------


# around line 13


               <span class="postbody">{MESSAGE}</span>





# 


#-----[ AFTER, ADD ]---------------------------------------


# Do NOT make one line out of this, a <!-- --> template statement has to be on one seperate line


               <!-- BEGIN postrow -->


               {ATTACHMENTS}


               <!-- END postrow -->





# 


#-----[ OPEN ]---------------------------------------------


# 


templates/subSilver/posting_topic_review.tpl





# 


#-----[ FIND ]---------------------------------------------


# around line 26


            <td colspan="2"><span class="postbody">{postrow.MESSAGE}</span></td>





# 


#-----[ IN-LINE FIND ]---------------------------------------------


# around line 26 (directly in that line)


{postrow.MESSAGE}</span>





# 


#-----[ IN-LINE AFTER, ADD ]---------------------------------------


# 


{postrow.ATTACHMENTS}





# 


#-----[ OPEN ]---------------------------------------------


# 


templates/subSilver/privmsgs_body.tpl





# 


#-----[ FIND ]---------------------------------------------


# around line 15


<table border="0" cellspacing="0" cellpadding="0" align="center" width="100%">


  <tr> 





# 


#-----[ AFTER, ADD ]---------------------------------------


# 


   <td align="right"> 


   <!-- BEGIN switch_box_size_notice -->


   <table width="175" cellspacing="1" cellpadding="2" border="0" class="bodyline">


   <tr> 


      <td colspan="3" width="175" class="row1" nowrap="nowrap"><span class="gensmall">{ATTACH_BOX_SIZE_STATUS}</span></td>


   </tr>


   <tr> 


      <td colspan="3" width="175" class="row2">


         <table cellspacing="0" cellpadding="1" border="0">


         <tr> 


            <td bgcolor="{T_TD_COLOR2}"><img src="templates/subSilver/images/spacer.gif" width="{ATTACHBOX_LIMIT_IMG_WIDTH}" height="8" alt="{ATTACH_LIMIT_PERCENT}" /></td>


         </tr>


         </table>


      </td>


   </tr>


   <tr> 


      <td width="33%" class="row1"><span class="gensmall">0%</span></td>


      <td width="34%" align="center" class="row1"><span class="gensmall">50%</span></td>


      <td width="33%" align="right" class="row1"><span class="gensmall">100%</span></td>


   </tr>


   </table>


   <!-- END switch_box_size_notice -->


   </td>





# 


#-----[ FIND ]---------------------------------------------


# around line 106


     <td width="55%" valign="middle" class="{listrow.ROW_CLASS}"><span class="topictitle">&nbsp;<a href="{listrow.U_READ}" class="topictitle">{listrow.SUBJECT}</a></span></td>





# 


#-----[ IN-LINE FIND ]---------------------------------------------


# around line 106 (directly in that line)


<span class="topictitle">&nbsp;<a href="{listrow.U_READ}" class="topictitle">{listrow.SUBJECT}





# 


#-----[ IN-LINE BEFORE, ADD ]---------------------------------------


# 


{listrow.PRIVMSG_ATTACHMENTS_IMG}





# 


#-----[ OPEN ]---------------------------------------------


# 


templates/subSilver/privmsgs_preview.tpl





# 


#-----[ FIND ]---------------------------------------------


# around line 23


   <td valign="top" colspan="2" class="row1"><span class="postbody">{MESSAGE}</span></td>





# 


#-----[ REPLACE WITH ]---------------------------------------


# Do NOT make one line out of this, a <!-- --> template statement has to be on one seperate line


   <td valign="top" colspan="2" class="row1"><span class="postbody">{MESSAGE}</span>


   <!-- BEGIN postrow -->


   {ATTACHMENTS}


   <!-- END postrow -->


   </td>





# 


#-----[ OPEN ]---------------------------------------------


# 


templates/subSilver/privmsgs_read_body.tpl





# 


#-----[ FIND ]---------------------------------------------


# around line 47


     <td valign="top" colspan="3" class="row1"><span class="postbody">{MESSAGE}</span></td>





# 


#-----[ REPLACE WITH ]---------------------------------------


# Do NOT make one line out of this, a <!-- --> template statement has to be on one seperate line


     <td valign="top" colspan="3" class="row1"><span class="postbody">{MESSAGE}</span>


<!-- BEGIN postrow -->


   {ATTACHMENTS}


<!-- END postrow -->


     </td>





# 


#-----[ FIND ]---------------------------------------------


# around line 74


      <input type="submit" name="delete" value="{L_DELETE_MSG}" class="liteoption" />





# 


#-----[ AFTER, ADD ]---------------------------------------


# Do NOT make one line out of this, a <!-- --> template statement has to be on one seperate line


<!-- BEGIN switch_attachments -->


      &nbsp; 


      <input type="submit" name="pm_delete_attach" value="{L_DELETE_ATTACHMENTS}" class="liteoption" />


<!-- END switch_attachments -->





# 


#-----[ OPEN ]---------------------------------------------


# 


templates/subSilver/profile_view_body.tpl





# 


#-----[ FIND ]---------------------------------------------


# around line 41


        <td> <b><span class="gen">{INTERESTS}</span></b></td>


      </tr>





# 


#-----[ AFTER, ADD ]---------------------------------------


# 


<!-- BEGIN switch_upload_limits -->


      <tr> 


         <td valign="top" align="right" nowrap="nowrap"><span class="gen">{L_UPLOAD_QUOTA}:</span></td>


         <td> 


            <table width="175" cellspacing="1" cellpadding="2" border="0" class="bodyline">


            <tr> 


               <td colspan="3" width="100%" class="row2">


                  <table cellspacing="0" cellpadding="1" border="0">


                  <tr> 


                     <td bgcolor="{T_TD_COLOR2}"><img src="templates/subSilver/images/spacer.gif" width="{UPLOAD_LIMIT_IMG_WIDTH}" height="8" alt="{UPLOAD_LIMIT_PERCENT}" /></td>


                  </tr>


                  </table>


               </td>


            </tr>


            <tr> 


               <td width="33%" class="row1"><span class="gensmall">0%</span></td>


               <td width="34%" align="center" class="row1"><span class="gensmall">50%</span></td>


               <td width="33%" align="right" class="row1"><span class="gensmall">100%</span></td>


            </tr>


            </table>


            <b><span class="genmed">[{UPLOADED} / {QUOTA} / {PERCENT_FULL}]</span> </b><br />


            <span class="genmed"><a href="{U_UACP}" class="genmed">{L_UACP}</a></span></td>


         </td>


      </tr>


<!-- END switch_upload_limits -->





# 


#-----[ OPEN ]---------------------------------------------


# 


templates/subSilver/viewforum_body.tpl





# 


#-----[ FIND ]---------------------------------------------


# around line 26


     <td class="row1" width="100%"><span class="topictitle">{topicrow.NEWEST_POST_IMG}{topicrow.TOPIC_TYPE}<a href="{topicrow.U_VIEW_TOPIC}" class="topictitle">{topicrow.TOPIC_TITLE}</a></span><span class="gensmall"><br />





# 


#-----[ IN-LINE FIND ]---------------------------------------------


# around line 26 (directly in that line)


{topicrow.NEWEST_POST_IMG}





# 


#-----[ IN-LINE AFTER, ADD ]---------------------------------------


# 


{topicrow.TOPIC_ATTACHMENT_IMG}





# 


#-----[ OPEN ]---------------------------------------------


# 


templates/subSilver/viewtopic_body.tpl





# 


#-----[ FIND ]---------------------------------------------


# around line 39


            <td colspan="2"><span class="postbody">{postrow.MESSAGE}{postrow.SIGNATURE}</span><span class="gensmall">{postrow.EDITED_MESSAGE}</span></td>





# 


#-----[ IN-LINE FIND ]---------------------------------------------


# around line 39 (directly in that line)


{postrow.SIGNATURE}





# 


#-----[ IN-LINE BEFORE, ADD ]---------------------------------------


# 


</span>{postrow.ATTACHMENTS}<span class="postbody">





# 


#-----[ OPEN ]---------------------------------------------


# 


templates/subSilver/admin/group_edit_body.tpl





# 


#-----[ FIND ]---------------------------------------------


# around line 48


   <!-- END group_edit -->





# 


#-----[ BEFORE, ADD ]---------------------------------------


# 


   <tr> 


     <td class="row1"><span class="gen">{L_UPLOAD_QUOTA}</span></td>


     <td class="row2">{S_SELECT_UPLOAD_QUOTA}</td>


   </tr>


   <tr> 


     <td class="row1"><span class="gen">{L_PM_QUOTA}</span></td>


     <td class="row2">{S_SELECT_PM_QUOTA}</td>


   </tr>





# 


#-----[ OPEN ]---------------------------------------------


# 


templates/subSilver/admin/user_edit_body.tpl





# 


#-----[ FIND ]---------------------------------------------


# around line 267


     <td class="row1" colspan="2"><span class="gensmall">{L_SPECIAL_EXPLAIN}</span></td>


   </tr>





# 


#-----[ AFTER, ADD ]---------------------------------------


# 


   <tr> 


     <td class="row1"><span class="gen">{L_UPLOAD_QUOTA}</span></td>


     <td class="row2">{S_SELECT_UPLOAD_QUOTA}</td>


   </tr>


   <tr> 


     <td class="row1"><span class="gen">{L_PM_QUOTA}</span></td>


     <td class="row2">{S_SELECT_PM_QUOTA}</td>


   </tr>

Posted: Fri Jan 09, 2009 4:41 pm

A theme would not cause these kinds of SQL Errors.

Have you looked to see if these tables exist? If they do not and this is not an update try running the installation again.

Posted: Fri Jan 09, 2009 4:42 pm

spasticdonkey wrote:

Either you didnt install the tables for the attachment mod, or the theme you are using doesn't have the attachment mod changes...

i changed my thems but the problem don't change.

for instal the tables, where i have to have a look?

Posted: Fri Jan 09, 2009 5:04 pm

What is a right query to instal that table:

nuke_bbattachments_config

Posted: Fri Jan 09, 2009 7:03 pm

You have to look in INSTALLTION/sql/rn_core around line 752 to install this table with phpMyAdmin but I wonder that the tables aren´t installed.
Maybe you are missing some more tables ? I would follow Palpin`s suggestion and run the installation again. This will delete all tables in your database and you start fresh.

registered · Posted: Fri Jan 09, 2009 9:08 pm

Is this an upgrade from an existing site? If so, you will need to use the table utilities provided to get your database tables compatible with 2.3

registered · Posted: Fri Jan 09, 2009 9:14 pm

Yeah, does sound like a migration from a non-RavenNuke(tm) install (i.e., existing site) to RN. The HowToInstall manual has some guidance as to what you need to do. It will point you to the INSTALLATION/sql/includedInCore directory too for the new tables. However, with RN 2.3.0, it has gotten more complex due to RNYA being so different now.

You may need to do what evaders99 has suggested and use something like MySQLDiff to compare your site's tables structure with that of a fresh install of the RN tables.

Posted: Sat Jan 10, 2009 7:12 am

During the installation I saw some setting raccomandation are red:

Register Globals ( Recommended OFF) (Actual ON)
Output Buffering ( Recommended ON) (Actual OFF)

What are these values and how it may change once the installation is finished?

Posted: Sat Jan 10, 2009 7:14 am

During i load i first step (Core table)
it show this message:

The exact error message that your MySQL server reported is:
MySQL Error # 4 at line 113 in file installSQL.php ==> Too big column length for column 'type' (max = 255). Use BLOB instead

Error in rn_core.sql at line 708:
CREATE TABLE `nuke_seo_subscriptions` ( `sid` int(6) NOT NULL auto_increment, `type` varchar(256) NOT NULL, `name` varchar(60) NOT NULL, `tagline` varchar(60) NOT NULL, `image` varchar(256) NOT NULL, `icon` varchar(256) NOT NULL, `url` varchar(256) NOT NULL, `active` int(1) NOT NULL, PRIMARY KEY (`sid`)) TYPE=MyISAM;

what can i do?

Posted: Sat Jan 10, 2009 7:47 am

Here is the fix:

http://www.ravenphpscripts.com/posts16515-highlight-nukeseosubscriptions.html

and for register globals on/off and the security risk are a lot of entires:
Check this:

http://www.ravenphpscripts.com/posts16890-highlight-register+globals.html

Please use also the search function !

Posted: Sat Jan 10, 2009 8:09 am

Susann wrote:

Here is the fix:

http://www.ravenphpscripts.com/posts16515-highlight-nukeseosubscriptions.html

ok, now it's ok.

Susann wrote:

Please use also the search function

ok, but my english is not very good Embarassed

Posted: Sat Jan 10, 2009 8:14 am

I know how hard it is if you don´t have the language skills but many questions are already answered.
Use a translator tool or an extension in firefox to translate. Maybe this helps.
So if you install your 2.30 version fresh, wich means you rerun installSQL.php please check at the bottom if there any errors.

Posted: Sun Jan 11, 2009 7:56 am

sleepers wrote:

During the installation I saw some setting raccomandation are red:

Register Globals ( Recommended OFF) (Actual ON)
Output Buffering ( Recommended ON) (Actual OFF)

What are these values and how it may change once the installation is finished?

None of these will be changed by the installation routine. The installer lets you know ahead of time what we recommend for these settings in order to tighten up security and/or to keep you from possibly having other issues.

Adding the following two lines into your .htaccess file in the root of your RavenNuke(tm) directory (i.e., where rnconfig.php is) should get these to recommended values:

php_flag output_buffering on
php_flag register_globals off