Find
Code: Select all
trigger_error('NO_TOPIC');
}
Code: Select all
$topic_title = $topic_data['topic_title'];
$forum_name = $topic_data['forum_name'];
do i Edit each time or just 1 time ?
Code: Select all
trigger_error('NO_TOPIC');
}
Code: Select all
$topic_title = $topic_data['topic_title'];
$forum_name = $topic_data['forum_name'];
Really can't give you any advice, but I too am hosted with bluehost and they support mod_rewriteXToF.be wrote:I changed to another host (bluehost). So I copied all the files from the old server to the new server, made a new database on the new server and created a username for the database. After this I changed my config.php file.
Since the .htaccess file was not included in the copied files of the old server (.htaccess on the old server is not shown in the ftp-program), I made a new .htaccess file. This file has only the code lines that can be found in the installation file of this MOD in it. To test it, I dropped this file on the old server in the root folder and there are no problems on my board. So this file should be ok.
At the moment my website is running on a temporary web adress:
http://69.89.31.234/~antforum/
When placing the .htaccess file on the new server, any link to a topic or forum generates an infite URL. e.g. http://69.89.31.234/~antforum/~antforum ... a12455e196
I tested if my new host supports mod_rewrite, so I checked the '/test-t1.html' page, which resulted in a 404 error.
I contacted my new host to ask if mod_rewrite is supported and they confirmed. When I asked if mod_rewrite is supported on the temporary web adress they answered: 'Yes it should'.
Can somebody give me some advice?
Code: Select all
$view_topic_url = append_sid("{$phpbb_root_path}viewtopic.$phpEx", "f=$u_forum_id&t=$result_topic_id" . (($u_hilit) ? "&hilit=$u_hilit" : ''));
Code: Select all
$view_topic_url = format_url($row['topic_title'], "t$result_topic_id", $start);
After reading through all the pages, looks like this hasn't been fixed yet.Bawls wrote:Hey all,
I finished up installing this mod. It's working great, however I have one issue. When a topic notification email is received, the link to the topic reply (i.e.: http://specv.net/forum/11may08-updates- ... 1823#p1823) runs into a 404.
Any ideas?
These are the php code lines of the mentioned .php files:Algemene fout
SQL ERROR [ mysqli ]
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'phpbb_topics t WHERE t.topic_id = p.topic_id AND t.topic_id = 1496' at line 3 [1064]
SQL
SELECT t.topic_title FROM phpbb_posts p phpbb_topics t WHERE t.topic_id = p.topic_id AND t.topic_id = 1496
BACKTRACE
FILE: includes/db/mysqli.php
LINE: 143
CALL: dbal->sql_error()
FILE: includes/functions_seo.php
LINE: 164
CALL: dbal_mysqli->sql_query()
FILE: viewtopic.php
LINE: 62
CALL: moved_topic()
Code: Select all
function sql_query($query = '', $cache_ttl = 0)
125 {
126 if ($query != '')
127 {
128 global $cache;
129
130 // EXPLAIN only in extra debug mode
131 if (defined('DEBUG_EXTRA'))
132 {
133 $this->sql_report('start', $query);
134 }
135
136 $this->query_result = ($cache_ttl && method_exists($cache, 'sql_load')) ? $cache->sql_load($query) : false;
137 $this->sql_add_num_queries($this->query_result);
138
139 if ($this->query_result === false)
140 {
141 if (($this->query_result = @mysqli_query($this->db_connect_id, $query)) === false)
142 {
143 $this->sql_error($query);
144 }
145
146 if (defined('DEBUG_EXTRA'))
147 {
148 $this->sql_report('stop', $query);
149 }
150
151 if ($cache_ttl && method_exists($cache, 'sql_save'))
152 {
153 $cache->sql_save($query, $this->query_result, $cache_ttl);
154 }
155 }
156 else if (defined('DEBUG_EXTRA'))
157 {
158 $this->sql_report('fromcache', $query);
159 }
160 }
161 else
162 {
163 return false;
164 }
165
166 return ($this->query_result) ? $this->query_result : false;
167 }
Code: Select all
141 function moved_topic($id, $type, $start = 0)
142 {
143 global $phpbb_root_path, $phpEx, $db;
144
145 $path = (!empty($_SERVER['REQUEST_URI'])) ? $_SERVER['REQUEST_URI'] : getenv('REQUEST_URI');
146 if (substr($path, 1, 10 + strlen($phpEx)) == 'viewtopic.' . $phpEx)
147 {
148 if ($type == 'topic')
149 {
150 $sql = 'SELECT topic_title
151 FROM ' . TOPICS_TABLE . "
152 WHERE topic_id = $id";
153 $newid = "t$id";
154 }
155 else
156 {
157 $sql = 'SELECT t.topic_title
158 FROM ' . POSTS_TABLE . ' p
159 ' . TOPICS_TABLE . " t
160 WHERE t.topic_id = p.topic_id
161 AND t.topic_id = $id";
162 $newid = "p$id";
163 }
164 $result = $db->sql_query($sql);
165 $topic_title = clean_url($db->sql_fetchfield('topic_title'));
166 $db->sql_freeresult($result);
167
168 header('HTTP/1.1 301 Moved Permanently');
169 header('Location: ' . format_url($topic_title, $newid, $start));
170 exit();
171 }
172 return;
173 }
Code: Select all
50 // Do we have a topic or post id?
51 if (!$topic_id && !$post_id)
52 {
53 trigger_error('NO_TOPIC');
54 }
55 $id = $topic_id;
56 $type = 'topic';
57 if (!$topic_id)
58 {
59 $id = $post_id;
60 $type = 'post';
61 }
62 moved_topic($id, $type);
Code: Select all
$sql = 'SELECT t.topic_title
FROM ' . POSTS_TABLE . ' p
' . TOPICS_TABLE . " t
WHERE t.topic_id = p.topic_id
AND t.topic_id = $id";
$newid = "p$id";
Code: Select all
$sql = 'SELECT t.topic_title
FROM ' . POSTS_TABLE . ' p,
' . TOPICS_TABLE . " t
WHERE t.topic_id = p.topic_id
AND p.post_id = $id";
$newid = "p$id";
I finally managed to fix this. Here's the fix:pappfer wrote:I'm having a different pagination error. When I'm browsing a topic and it has like 10 pages and I click on for example page 10 (within the topic) it only puts me on page 6 (it can't jump more then 5 pages).
Code: Select all
$page_string .= ($on_page == $total_pages) ? '<strong>' . $total_pages . '</strong>' : '<a href="' . append_seo_sid($base_url . 's' . (($i - 1) * $per_page) . $append) . '">' . $total_pages . '</a>';
Code: Select all
$page_string .= ($on_page == $total_pages) ? '<strong>' . $total_pages . '</strong>' : '<a href="' . append_seo_sid($base_url . 's' . (($total_pages - 1) * $per_page) . $append) . '">' . $total_pages . '</a>';
Any fix for this??Ann_L wrote:On selecting a forum from the option box(jumpbox which lists all the forums) in the viewforum.php & viewtopic.php, the url goes to viewforum.php.. It is not called by the new url. Anyone have worked on it?
Code: Select all
General Error
SQL ERROR [ mysql4 ]
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'FROM phpbb_topics WHERE topic_id = 41' at line 2 [1064]
SQL
SELECT forum_id , FROM phpbb_topics WHERE topic_id = 41
BACKTRACE
FILE: includes/db/mysql.php
LINE: 158
CALL: dbal_mysql->sql_error()
FILE: viewtopic.php
LINE: 55
CALL: dbal_mysql->sql_query()