PHP Web Host - Quality Web Hosting For All PHP Applications Just Great Software
  Login or Register
 • Home • Downloads • Your Account • Forums • 

View next topic
View previous topic


Google
 
Web RavenPHPScripts (This Site)
Post new topic   Reply to topic
Author Message
sleepers
New Member
New Member


Joined: Dec 29, 2007
Posts: 16
Location: Verona - Italy

PostPosted: Fri Jan 09, 2009 3:55 pm Reply with quote Back to top

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 :
Only registered users can see links on this board!
Get registered or login to the forums!

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?
View user's profile Send private message
spasticdonkey
RavenNuke(tm) Development Team


Joined: Dec 02, 2006
Posts: 1359
Location: Texas, USA

PostPosted: Fri Jan 09, 2009 4:12 pm Reply with quote Back to top

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>

View user's profile Send private message
Palbin
Site Admin


Joined: Mar 30, 2006
Posts: 2450
Location: Pittsburgh, Pennsylvania

PostPosted: Fri Jan 09, 2009 4:41 pm Reply with quote Back to top

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.
View user's profile Send private message
sleepers
New Member
New Member


Joined: Dec 29, 2007
Posts: 16
Location: Verona - Italy

PostPosted: Fri Jan 09, 2009 4:42 pm Reply with quote Back to top

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?
View user's profile Send private message
sleepers
New Member
New Member


Joined: Dec 29, 2007
Posts: 16
Location: Verona - Italy

PostPosted: Fri Jan 09, 2009 5:04 pm Reply with quote Back to top

What is a right query to instal that table:

nuke_bbattachments_config
View user's profile Send private message
Susann
Moderator


Joined: Dec 19, 2004
Posts: 3143
Location: Germany:Moderator German NukeSentinel Support

PostPosted: Fri Jan 09, 2009 7:03 pm Reply with quote Back to top

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.
View user's profile Send private message Visit poster's website
evaders99
Former Moderator in Good Standing


Joined: Apr 30, 2004
Posts: 3221

PostPosted: Fri Jan 09, 2009 9:08 pm Reply with quote Back to top

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
View user's profile Send private message Visit poster's website
montego
Site Admin


Joined: Aug 29, 2004
Posts: 9133
Location: Arizona

PostPosted: Fri Jan 09, 2009 9:14 pm Reply with quote Back to top

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.
View user's profile Send private message Visit poster's website
sleepers
New Member
New Member


Joined: Dec 29, 2007
Posts: 16
Location: Verona - Italy

PostPosted: Sat Jan 10, 2009 7:12 am Reply with quote Back to top

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?
View user's profile Send private message
sleepers
New Member
New Member


Joined: Dec 29, 2007
Posts: 16
Location: Verona - Italy

PostPosted: Sat Jan 10, 2009 7:14 am Reply with quote Back to top

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?
View user's profile Send private message
Susann
Moderator


Joined: Dec 19, 2004
Posts: 3143
Location: Germany:Moderator German NukeSentinel Support

PostPosted: Sat Jan 10, 2009 7:47 am Reply with quote Back to top

Here is the fix:
Only registered users can see links on this board!
Get registered or login to the forums!


and for register globals on/off and the security risk are a lot of entires:
Check this:
Only registered users can see links on this board!
Get registered or login to the forums!



Please use also the search function !
View user's profile Send private message Visit poster's website
sleepers
New Member
New Member


Joined: Dec 29, 2007
Posts: 16
Location: Verona - Italy

PostPosted: Sat Jan 10, 2009 8:09 am Reply with quote Back to top

Susann wrote:
Here is the fix:
Only registered users can see links on this board!
Get registered or login to the forums!




ok, now it's ok.


Susann wrote:

Please use also the search function


ok, but my english is not very good Embarassed
View user's profile Send private message
Susann
Moderator


Joined: Dec 19, 2004
Posts: 3143
Location: Germany:Moderator German NukeSentinel Support

PostPosted: Sat Jan 10, 2009 8:14 am Reply with quote Back to top

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.
View user's profile Send private message Visit poster's website
montego
Site Admin


Joined: Aug 29, 2004
Posts: 9133
Location: Arizona

PostPosted: Sun Jan 11, 2009 7:56 am Reply with quote Back to top

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
View user's profile Send private message Visit poster's website
Display posts from previous:       
Post new topic   Reply to topic

View next topic
View previous topic
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
Forums ©
 

All logos and trademarks in this site are property of their respective owner.
The comments are property of their posters, all the rest © 2002-2011 by Raven

You can syndicate our news using the file xml

CSE HTML Validator Helped Clean up This Page! [Valid RSS] valid RSS 2.0 Valid robots.txt Stop Spam Harvesters, Join Project Honey Pot

Website engines core code is © copyright by PHP-Nuke but has been heavily patched and modified by myself and others.
PHP-Nuke is a free software released under the GNU/GPL.


:: fisubice phpbb2 style by Daz :: PHP-Nuke theme by www.nukemods.com ::
:: fisubice Theme Modified by the RavenNuke™ Team ::

:: W3C CSS Compliance Validation :: W3C HTML 4.01 Transitional Compliance Validation ::

zerosum