It's likely that a later version of the Categories Hierarchy mod removed that file. Unfortunately, I don't have the time, right now, to get it to work, either. Maybe someone on Ptirhiik's board can help you out. Good luck!Alundra wrote:lol
i did that. its done but when i tried to install the hierarchy thing it said
Could not open [includes/functions_categories_hierarchy.php] for reading.
it doesnt exist in the mod folder, or my phpBB folder.
what can i do?
So I tried to run the query in phpmyadmin (granted I may have done it wrong because I'm not too experienced with doing this). I basically logged into phpmyadmin, chose the database I wanted to use (gamerwidow_phpbb) and clicked on the SQL tab. Then I pasted this:SQL PROCESSING HALTED
An error was encountered while processing the SQL commands. Further SQL processing has been halted. You may choose to complete the MOD installation anyway and perform the SQL commands manually yourself. However, at this point EM cannot guarantee the MOD will work correctly so you are best off seeking support from the Author before continuing further.
The failed line was:
UPDATE users AS u,posts AS p1 LEFT OUTER JOIN posts AS p2 ON p1.poster_id = p2.poster_id AND p2.post_time < p1.post_time INNER JOIN posts AS p3 ON p3.post_time = p1.post_time SET u.user_firstpost=p3.post_time WHERE p2.post_time IS NULL AND p1.poster_id = u.user_id;;
SQL ERROR: 1064
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 '; p1.post_time INNER JOIN posts AS p3 ON p3.post_time = p1.post_time SET u.user_' at line 1
Code: Select all
UPDATE phpbb_users AS u, phpbb_posts AS p1
LEFT OUTER JOIN
phpbb_posts AS p2
ON p1.poster_id = p2.poster_id AND
p2.post_time < p1.post_time
INNER JOIN
phpbb_posts AS p3
ON p3.post_time = p1.post_time
SET u.user_firstpost=p3.post_time
WHERE p2.post_time IS NULL AND
p1.poster_id = u.user_id;
import.php: Missing parameter: import_type (FAQ 2.8)
import.php: Missing parameter: format (FAQ 2.8)