"You must activate SQL Rewriting to use this script" BUT

Discussions and support about the different URL Rewriting techniques for phpBB.

Moderator: Moderators

Re: "You must activate SQL Rewriting to use this script" BUT

Postby Stephen26 » Wed Dec 28, 2011 6:55 pm

OK, thanks for the info, I misinterpreted that. I don't get an 500 error when trying to open the phpbb_cache.php of my board in a browser, just a blank screen by the way.
I install and configure phpBB-SEO (and other mods) for a fair price and very fast. If you are interested simply send me a private message.
Stephen26
phpBB SEO Team
phpBB SEO Team
 
Posts: 426
Joined: Mon May 03, 2010 7:06 am

Advertisement

Re: "You must activate SQL Rewriting to use this script" BUT

Postby coyote » Wed Dec 28, 2011 7:01 pm

Stephen26 wrote:I don't get an 500 error when trying to open the phpbb_cache.php of my board in a browser, just a blank screen by the way.


Yeah, same here. There may be something else going on with his permission system.
coyote
phpBB SEO Team
phpBB SEO Team
 
Posts: 284
Joined: Fri May 11, 2007 6:24 am

Re: "You must activate SQL Rewriting to use this script" BUT

Postby RobertKS » Wed Dec 28, 2011 7:05 pm

coyote wrote:You should also have .htaccess and .htaccess.current in that same directory.


Nope, they're not there. What should they look like?

Here's phpbb_cache.php.current:

Code: Select all
<?php
/**
* phpBB_SEO Class
* www.phpBB-SEO.com
* @package Advanced phpBB3 SEO mod Rewrite
*/
if (!defined('IN_PHPBB')) {
   exit;
}
$this->cache_config['settings'] = array ( 'url_rewrite' => true, 'modrtype' => 3, 'sql_rewrite' => true, 'profile_inj' => true, 'profile_vfolder' => false, 'profile_noids' => false, 'rewrite_usermsg' => true, 'rewrite_files' => false, 'rem_sid' => false, 'rem_hilit' => true, 'rem_small_words' => true, 'virtual_folder' => true, 'cache_layer' => true, 'rem_ids' => false, 'copyrights' => array ( 'img' => false, 'txt' => '', 'title' => '', ), );
$this->cache_config['forum'] = array ( 1 => 'law-f1', 2 => 'patents-f2', 3 => 'copyrights-f3', 4 => 'trademarks-f4', 6 => 'careers-f6', 5 => 'uspto-f5', 7 => 'patent-agent-attorney-f7', );
?>


and here's phpbb_cache.php.old:

Code: Select all
<?php
/**
* phpBB_SEO Class
* www.phpBB-SEO.com
* @package Advanced phpBB3 SEO mod Rewrite
*/
if (!defined('IN_PHPBB')) {
   exit;
}
$this->cache_config['settings'] = array ( 'url_rewrite' => true, 'modrtype' => 3, 'sql_rewrite' => true, 'profile_inj' => true, 'profile_vfolder' => false, 'profile_noids' => false, 'rewrite_usermsg' => true, 'rewrite_files' => false, 'rem_sid' => false, 'rem_hilit' => true, 'rem_small_words' => true, 'virtual_folder' => true, 'cache_layer' => true, 'rem_ids' => false, 'copyrights' => array ( 'img' => false, 'txt' => '', 'title' => '', ), );
$this->cache_config['forum'] = array ( 1 => 'law-f1', 2 => 'patents-f2', 3 => 'copyrights-f3', 4 => 'trademarks-f4', 6 => 'careers-f6', 5 => 'uspto-f5', 7 => 'patent-agent-attorney-f7', );
?>


Thanks for the help, BTW.
RobertKS
 
Posts: 26
Joined: Tue Dec 27, 2011 10:31 am

Re: "You must activate SQL Rewriting to use this script" BUT

Postby coyote » Wed Dec 28, 2011 7:19 pm

RobertKS wrote:
Nope, they're not there. What should they look like?


You probably don't have see hidden files turned on in your ftp client.


RobertKS wrote:Thanks for the help, BTW.


You're welcome! Glad to help.
coyote
phpBB SEO Team
phpBB SEO Team
 
Posts: 284
Joined: Fri May 11, 2007 6:24 am

Re: "You must activate SQL Rewriting to use this script" BUT

Postby RobertKS » Wed Dec 28, 2011 8:21 pm

coyote wrote:You probably don't have see hidden files turned on in your ftp client.


Well, I can see .htaccess files in other directories, where they appear slightly grayed, so I don't think that's the problem. (I'm using WinSCP as my client.)
RobertKS
 
Posts: 26
Joined: Tue Dec 27, 2011 10:31 am

Re: "You must activate SQL Rewriting to use this script" BUT

Postby coyote » Wed Dec 28, 2011 10:10 pm

Oh. Hmm. I think in order to help better with this I would need a vanilla board with just ultimate seo url installed. My folder has an .htaccess and an .htaccess.current, but I've done a ton of mods and changes to it since I started off with the premod. I have always used the premod and had excellent results.
coyote
phpBB SEO Team
phpBB SEO Team
 
Posts: 284
Joined: Fri May 11, 2007 6:24 am

Re: "You must activate SQL Rewriting to use this script" BUT

Postby raster » Thu Jan 26, 2012 12:27 pm

Stephen26 wrote:Are the /phpbb_seo/cache/ directory + phpbb_cache.php writeable? Does downloading the phpbb_seo/cache/phpbb_cache.php file and changing 'url_rewrite' => false to 'url_rewrite' => true and reuploading work?


Both are true and permissions are correct.
raster
 
Posts: 6
Joined: Sat Jul 02, 2011 2:36 pm

Re: "You must activate SQL Rewriting to use this script" BUT

Postby Stephen26 » Thu Jan 26, 2012 1:00 pm

coyote wrote:From this error you posted, Fatal error: Call to a member function set_url() on a non-object in [my webroot]/phpbb_seo/sync_url.php on line 78, it sounds like one of your forum or topic id's is missing, or it doesn't like what you named one of the topics, but that's a guess. I'm still learning PHP.

Based on coyote's guess using the Support Tool Kit option -> Fix Left/Right ID's might be worth a shot. It checks and if necessary repairs the tree structure of forums and modules.
I install and configure phpBB-SEO (and other mods) for a fair price and very fast. If you are interested simply send me a private message.
Stephen26
phpBB SEO Team
phpBB SEO Team
 
Posts: 426
Joined: Mon May 03, 2010 7:06 am

Re: "You must activate SQL Rewriting to use this script" BUT

Postby RobertKS » Thu Jan 26, 2012 2:34 pm

Thanks, Stephen. FYI, I don't have this problem anymore after installing premod 3.0.10, but now I have the problem described in the Jan. 20, 2012 post to this thread:

My Administrator Control Panel > PHPBB SEO tab > Extended config page is missing the Page titles section (and perhaps other sections) ... [and] the Related topics section is displayed by what appears to be a PHP constant name, RELATED_TOPICS ...


In addition to the problems above, the header to any "related topics" section on a topic page is rendered as { RELATED_TOPICS }. I'm not sure why, but I'm guessing it's a related issue. See, e.g., this topic (at the bottom of the page).
RobertKS
 
Posts: 26
Joined: Tue Dec 27, 2011 10:31 am

Re: "You must activate SQL Rewriting to use this script" BUT

Postby Stephen26 » Thu Jan 26, 2012 3:01 pm

Do you also have this problem when using prosilver / subsilver2? Did you apply all necessary code changes to the eTech style, e.g.:

Code: Select all
#-----[ OPEN ]------------------------------------------
## MOD Title:       phpBB SEO Related Topics
## MOD Title:       phpBB SEO Ultimate SEO URL
#

styles/prosilver/template/viewtopic_body.html

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

<a href="#p{postrow.POST_ID}">

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

<a href="{U_VIEW_TOPIC}#p{postrow.POST_ID}">

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

<a href="#wrap" class="top" title="{L_BACK_TO_TOP}">

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

<a href="{U_VIEW_TOPIC}#wrap" class="top" title="{L_BACK_TO_TOP}">

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

<!-- IF S_TOPIC_MOD -->
   <form method="post" action="{S_MOD_ACTION}">
   <fieldset class="quickmod">
      <label for="quick-mod-select">{L_QUICK_MOD}:</label> {S_TOPIC_MOD} <input type="submit" value="{L_GO}" class="button2" />
      {S_FORM_TOKEN}
   </fieldset>
   </form>
<!-- ENDIF -->

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

<!-- IF S_RELATED_RESULTS --><div class="clear">&nbsp;</div><br /><br />
<div class="forumbg">
   <div class="inner"><span class="corners-top"><span></span></span>
      <ul class="topiclist">
         <li class="header">
            <dl class="icon">
               <dt>{L_RELATED_TOPICS}</dt>
               <dd class="posts">{L_REPLIES}</dd>
               <dd class="views">{L_VIEWS}</dd>
               <dd class="lastpost"><span>{L_LAST_POST}</span></dd>
            </dl>
         </li>
      </ul>

   <ul class="topiclist forums">
   <!-- BEGIN related -->
   <li class="row bg1<!-- IF related.S_POST_ANNOUNCE --> announce<!-- ENDIF --><!-- IF related.S_POST_STICKY --> sticky<!-- ENDIF --><!-- IF related.S_TOPIC_REPORTED --> reported<!-- ENDIF -->">
      <dl class="icon" style="background-image: url({related.TOPIC_FOLDER_IMG_SRC}); background-repeat: no-repeat;">
         <dt <!-- IF related.TOPIC_ICON_IMG and S_TOPIC_ICONS --> style="background-image: url({T_ICONS_PATH}{related.TOPIC_ICON_IMG}); background-repeat: no-repeat;"<!-- ENDIF -->><!-- IF related.S_UNREAD_TOPIC --><a href="{related.U_NEWEST_POST}">{NEWEST_POST_IMG}</a> <!-- ENDIF --><a class="topictitle" href="{related.U_TOPIC}" title="{related.TOPIC_TITLE} : {related.FORUM}">{related.TOPIC_TITLE}</a>
         <!-- IF related.S_TOPIC_UNAPPROVED --><a href="{related.U_MCP_QUEUE}">{UNAPPROVED_IMG}</a> <!-- ENDIF -->
         <!-- IF related.S_TOPIC_REPORTED --><a href="{related.U_MCP_REPORT}">{REPORTED_IMG}</a><!-- ENDIF --><br />
         <!-- IF related.PAGINATION --><strong class="pagination"><span>{related.PAGINATION}</span></strong><!-- ENDIF -->
         <!-- IF related.ATTACH_ICON_IMG -->{related.ATTACH_ICON_IMG} <!-- ENDIF -->{L_POST_BY_AUTHOR} {related.TOPIC_AUTHOR_FULL} &raquo; {related.FIRST_POST_TIME}
         </dt>
         <dd class="posts">{related.REPLIES} <dfn>{L_REPLIES}</dfn></dd>
         <dd class="views">{related.VIEWS} <dfn>{L_VIEWS}</dfn></dd>
         <dd class="lastpost"><span><dfn>{L_LAST_POST} </dfn>{L_POST_BY_AUTHOR} {related.LAST_POST_AUTHOR_FULL}
            <a href="{related.U_LAST_POST}">{LAST_POST_IMG}</a><br />{related.LAST_POST_TIME}
            <!-- IF related.U_FORUM and not related.S_POST_GLOBAL --><br /><a class="topictitle" href="{related.U_FORUM}" title="{related.FORUM}">{related.FORUM}</a><!-- ENDIF --></span></dd>
      </dl>
   </li>
   <!-- END related -->
   </ul>
   <span class="corners-bottom"><span></span></span></div>
</div>
<!-- ENDIF -->
I install and configure phpBB-SEO (and other mods) for a fair price and very fast. If you are interested simply send me a private message.
Stephen26
phpBB SEO Team
phpBB SEO Team
 
Posts: 426
Joined: Mon May 03, 2010 7:06 am

Re: "You must activate SQL Rewriting to use this script" BUT

Postby RobertKS » Thu Jan 26, 2012 3:21 pm

Yes, it's the same in prosilver, and yes, I've made all the changes to eTech that were required of subsilver2 (eTech being based on subsilver2).
RobertKS
 
Posts: 26
Joined: Tue Dec 27, 2011 10:31 am

Re: "You must activate SQL Rewriting to use this script" BUT

Postby Stephen26 » Thu Jan 26, 2012 3:29 pm

Open /language/en/common.php - Search for ?> - Does the code above look like this:

Code: Select all
// http://www.phpBB-SEO.com SEO TOOLKIT BEGIN - TITLE
$lang['Page'] = 'Page ';
// http://www.phpBB-SEO.com SEO TOOLKIT END - TITLE
// http://www.phpBB-SEO.com SEO TOOLKIT BEGIN -> GYM Sitemaps
$lang = array_merge($lang, array(
   'GYM_LINKS' => 'Links',
   'GYM_LINK' => 'Link',
   'GYM_RSS_SLIDE_START' => 'Start scroller',
   'GYM_RSS_SLIDE_STOP' => 'Stop scroller',
   'GYM_RSS_SOURCE' => 'Source',
));
// http://www.phpBB-SEO.com SEO TOOLKIT END -> GYM Sitemaps
// http://www.phpBB-SEO.com SEO TOOLKIT BEGIN - Related Topics
$lang['RELATED_TOPICS'] = 'Related topics';
// http://www.phpBB-SEO.com SEO TOOLKIT END - Related Topics
I install and configure phpBB-SEO (and other mods) for a fair price and very fast. If you are interested simply send me a private message.
Stephen26
phpBB SEO Team
phpBB SEO Team
 
Posts: 426
Joined: Mon May 03, 2010 7:06 am

Re: "You must activate SQL Rewriting to use this script" BUT

Postby RobertKS » Thu Jan 26, 2012 4:18 pm

That was the problem. I'm using the en-us language pack as default. When I imported the code you pointed out from the en language pack into the en-us language pack's common.php, it fixed the problems. Thanks!
RobertKS
 
Posts: 26
Joined: Tue Dec 27, 2011 10:31 am

Re: "You must activate SQL Rewriting to use this script" BUT

Postby Stephen26 » Sun Apr 21, 2013 4:03 pm

Posted in the wrong thread. :oops:

Post can be deleted.
I install and configure phpBB-SEO (and other mods) for a fair price and very fast. If you are interested simply send me a private message.
Stephen26
phpBB SEO Team
phpBB SEO Team
 
Posts: 426
Joined: Mon May 03, 2010 7:06 am

Previous

Return to phpBB mod Rewrite

 


  • Related topics
    Replies
    Views
    Last post

Who is online

Users browsing this forum: No registered users and 9 guests