Snitz to phpbb

This is an archive of the phpBB 2.0.x convertors forum. Support for phpBB2 has now ended.
Forum rules
Following phpBB2's EoL, this forum is now archived for reference purposes only.
Please see the following announcement for more information: viewtopic.php?f=14&t=1385785
Locked
User avatar
RalucaM
Registered User
Posts: 163
Joined: Thu Jan 24, 2002 1:42 am
Location: Romania
Contact:

Post by RalucaM »

Heynow
Registered User
Posts: 34
Joined: Sun Aug 17, 2003 2:13 pm
Contact:

Post by Heynow »

That worked.. :D

Thanks RalucaM!
cemalkaan
Registered User
Posts: 9
Joined: Sat Jan 03, 2004 6:37 pm

Post by cemalkaan »

Hi,
I converted access to snitz and When I want to convert database I got error...


insert anonymous into phpbb_groups
insert anonymous into phpbb_user_group
Admin
Çekirge
MySql error on query BR> INSERT INTO phpbb_users VALUES ( '3', '1', 'Çekirge', '7895b670f0051bfb70911bdd0f948fcb', 1071668411, 0, 1071158454, 989562324, '0', 1007, '2', 1, 'english', 'd M Y H:i', 0, 0, 0, 0, '1', '1', '0', '1', '1', '1', '1', '1', '1', '1', '1', 0, NULL, '0', 'mail@mailinfo.com', '12021', 'http://www.mailinfo.com', '', '100.Yilimizda Elele... Hersey gelecegin BESIKTAS\\'i için... Selamlar+Sevgiler... ', NULL, '', '444', NULL, '', '', NULL, NULL);
mysql_errno = 1064
mysql_error = 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 'i için... Selamlar+Sevgiler...' at line 38
User avatar
RalucaM
Registered User
Posts: 163
Joined: Thu Jan 24, 2002 1:42 am
Location: Romania
Contact:

Post by RalucaM »

Before conversion try to delete de \\ characters from that record: "BESIKTAS\\'i için...".
cemalkaan
Registered User
Posts: 9
Joined: Sat Jan 03, 2004 6:37 pm

Post by cemalkaan »

There is no \\ characters on the records...
User avatar
RalucaM
Registered User
Posts: 163
Joined: Thu Jan 24, 2002 1:42 am
Location: Romania
Contact:

Post by RalucaM »

In members.php file replace this line:

Code: Select all

$sig = strip_tags(str_replace("'", "\\'", $row[M_SIG]));
with

Code: Select all

$sig = strip_tags($row[M_SIG]);
Tell me if you go the same error.
cemalkaan
Registered User
Posts: 9
Joined: Sat Jan 03, 2004 6:37 pm

Post by cemalkaan »

Thanks no error with members and categories but forums and topics and posts..
User avatar
RalucaM
Registered User
Posts: 163
Joined: Thu Jan 24, 2002 1:42 am
Location: Romania
Contact:

Post by RalucaM »

Did you try to change the code? Did you got the same error? (it is because of the ' character).
cemalkaan
Registered User
Posts: 9
Joined: Sat Jan 03, 2004 6:37 pm

Post by cemalkaan »

I did members, forums and categories, it is ok...

But on topics if I change the code I get error on the first record, if I don't change the code, I got error on 15. record :(
User avatar
RalucaM
Registered User
Posts: 163
Joined: Thu Jan 24, 2002 1:42 am
Location: Romania
Contact:

Post by RalucaM »

Please copy/paste the error after running topics.php and posts.php. Or, if it is fine with you, send me the FORUM_TOPICS and FORUM_REPLY tables. (archived).
cemalkaan
Registered User
Posts: 9
Joined: Sat Jan 03, 2004 6:37 pm

Post by cemalkaan »

OK thanks for all...

I did it, I clean all ' from access database...

Now I am problem I can't change default language, I uploaded Turkish Language, I see from config, I select and post but but It doesn't change...
User avatar
RalucaM
Registered User
Posts: 163
Joined: Thu Jan 24, 2002 1:42 am
Location: Romania
Contact:

Post by RalucaM »

I think you only changed the language for the forum. Every user (including the administrator) can choose his own language. So go to your profile and change it.
cemalkaan
Registered User
Posts: 9
Joined: Sat Jan 03, 2004 6:37 pm

Post by cemalkaan »

Non user language is English, Visitors must see site Turkish, I select from config section and post and look again config section it is English again...

Is there any way to change all users default language to turkish by writing an sql script in phpmyadmin? And how ?
User avatar
RalucaM
Registered User
Posts: 163
Joined: Thu Jan 24, 2002 1:42 am
Location: Romania
Contact:

Post by RalucaM »

Go to SQL section in phpmyadmin and write this:

Code: Select all

UPDATE phpbb_users SET user_lang='turkish';
cemalkaan
Registered User
Posts: 9
Joined: Sat Jan 03, 2004 6:37 pm

Post by cemalkaan »

Thanks,
And now How can I set forum default language to Turkish I can't do from Conf section...
Locked

Return to “[2.0.x] Convertors”