3.0.10 - Categories Hierarchie To phpBB3 Convertor
-
- Registered User
- Posts: 32
- Joined: Mon Jul 26, 2004 10:36 am
-
- Former Team Member
- Posts: 11812
- Joined: Tue Jan 25, 2005 8:38 pm
- Location: New Hampshire, USA
- Name: Richard Foote
-
- Registered User
- Posts: 32
- Joined: Mon Jul 26, 2004 10:36 am
Re: 3.0.10
Does not work
Allegedly pours path is not correct. But the path is ok. The original convertor takes it.
// EDIT
Ok I have change to and the path is ok. But now grumbles the table prefix.
// EDIT 2
Ok is solve the prefix check.
But now
// EDIT 3
Now I change the database that NULL is accepted and the next problem is:
Allegedly pours path is not correct. But the path is ok. The original convertor takes it.
// EDIT
Ok I have change
Code: Select all
$test_file = 'usercp.php';
Code: Select all
$test_file = 'uacp.php';
// EDIT 2
Ok is solve the prefix check.
But now
SQL ERROR [ mysqli ]
Column 'forum_topics_per_page' cannot be null [1048]
// EDIT 3
Now I change the database that NULL is accepted and the next problem is:
SQL ERROR [ mysql4 ]
Unknown column 'user_bot_agent' in 'where clause' [1054]
-
- Registered User
- Posts: 32
- Joined: Mon Jul 26, 2004 10:36 am
Re: 3.0.10
What version of CH are you converting from?
Did it come as part of a premodded forum package?
OPEN functions_phpbb2CH.php
FIND
REPLACE WITHor REPLACE WITH
FINDRemove that whole section of code.
Did it come as part of a premodded forum package?
It appears that there is a typo in the convertor. You want to check the CH forums table structure to be sure. The field in CH might be either forum_topics_page or forum_topics_per_page.AmigaLink wrote:But now
Hide
SQL ERROR [ mysqli ]
Column 'forum_topics_per_page' cannot be null [1048]
// EDIT 3
Now I change the database that NULL is accepted and the next problem is:
OPEN functions_phpbb2CH.php
FIND
Code: Select all
'forum_topics_per_page' => $row['forum_topics_ppage'],
REPLACE WITH
Code: Select all
'forum_topics_per_page' => $row['forum_topics_page'],
Code: Select all
'forum_topics_per_page' => $row['forum_topics_per_page'],
OPEN functions_phpBB2CH.phpAmigaLink wrote:the next problem is:
Hide
SQL ERROR [ mysql4 ]
Unknown column 'user_bot_agent' in 'where clause' [1054]
FIND
Code: Select all
// And now those who have had their avatar rights removed get assigned a more restrictive role
$sql = 'SELECT user_id FROM ' . $convert->src_table_prefix . 'users
WHERE user_allowavatar = 0
AND user_id > 0
AND (
`user_bot_agent` = ""
OR `user_bot_agent` IS NULL
) AND (
`user_bot_ips` = ""
OR `user_bot_ips` IS NULL
)';
$result = $src_db->sql_query($sql);
while ($row = $src_db->sql_fetchrow($result))
{
mass_auth('user', 0, (int) phpbb_user_id($row['user_id']), 'u_chgavatar', ACL_NEVER);
}
$src_db->sql_freeresult($result);
// And the same for those who have had their PM rights removed
$sql = 'SELECT user_id FROM ' . $convert->src_table_prefix . 'users
WHERE user_allow_pm = 0
AND user_id > 0
AND (
`user_bot_agent` = ""
OR `user_bot_agent` IS NULL
) AND (
`user_bot_ips` = ""
OR `user_bot_ips` IS NULL
)';
$result = $src_db->sql_query($sql);
while ($row = $src_db->sql_fetchrow($result))
{
mass_auth('user', 0, (int) phpbb_user_id($row['user_id']), array('u_masspm','u_sendpm','u_readpm'),ACL_NEVER);
}
$src_db->sql_freeresult($result);
Have you hugged someone today?
-
- Former Team Member
- Posts: 11812
- Joined: Tue Jan 25, 2005 8:38 pm
- Location: New Hampshire, USA
- Name: Richard Foote
Re: 3.0.10
2.0.5RC2D¡cky wrote:What version of CH are you converting from?
No I do not like premod forums.Did it come as part of a premodded forum package?
My board is heavy self modded. There are approximately 100 MODs and a lot of own changes. Even the CH cache system is changed. It will be much faster than the original.
But I never change the DB entrys. So I wonder that the convertor makes trouble.
Thanks for the hints. I will check it next days.
-
- Registered User
- Posts: 32
- Joined: Mon Jul 26, 2004 10:36 am