TB DEV SZ разработка движка

Sryla писал(а):Нафаня помогай!

зачем ему это?

RoadTrain писал(а):

Sryla писал(а):Нафаня помогай!

зачем ему это?

Если есть конвертор то надо антиконвертор)

Sryla писал(а):

RoadTrain писал(а):

Sryla писал(а):Нафаня помогай!

зачем ему это?

Если есть конвертор то надо антиконвертор)

глупости и это точно не к Нафане

Помогите кто нить)

Hello,
I cant speak any Russian.
I use your converter and it starts nicely.
after a while it says :

Column count doesn't match value count at row 1 in sql INSERT INTO crete1_nafania.categories (id, name, image) SELECT * FROM crete1_tracker.categories on line 279

Any help?
Thank you

Google TRANSLATE :

Здравствуйте,
Я наклоняю говорить на любом русском языке.
Я использую ваш конвертор, и она начинает красиво.
Через некоторое время он говорит:

Column count doesn't match value count at row 1 in sql INSERT INTO crete1_nafania.categories (id, name, image) SELECT * FROM crete1_tracker.categories on line 279

Любая помощь?
Спасибо

I think it's because you use modified torrent strike and table categories in your torrentstrike different from original.
You must change converter for your db scheme.

For example, in base torrentstrike table categories has 3 rows - "id, name, image" and when converter does select

Код: Выделить всё

SELECT * FROM crete1_tracker.categories

it gives only three rows (id, name, image) and this three rows will inserts in tb dev sz database.

You have not three rows, then you must change this sql to something like this

Код: Выделить всё

SELECT id, name, image FROM crete1_tracker.categories

i.e. you must select only this three rows in that order.

hello, thank you for your help.

I removed the excess tables, i got an error below with phpbb, but i got over it again.
The conversiion completed successfuly - i have copied my pic folder and torrents folder to the directory.

The problem i have now is with encoding (my DB is latin1_general_ci) i want to see greek - windows1253/iso-88597 /or UTF) and it doesnt recognise usernames /passwords.

Another thing is that when the converter finished, i seem to be still missing StreamZone tables like - checkcomm_userid - or

Код: Выделить всё

SQL ERROR [ mysql4 ]

Unknown column 'c.cat_parent_id' in 'on clause' [1054]

SQL

SELECT t.fid, t.name, c.name AS cat_name, c.id AS cat_id, c2.name AS cat_parent_name, c2.id AS cat_parent_id FROM torrents t, categories c LEFT JOIN categories c2 ON ( c.cat_parent_id = c2.id ) WHERE t.category = c.id AND t.banned = 0 AND t.leechers > 0 AND c.anonymous_view = 1 ORDER BY t.seeders + t.leechers DESC LIMIT 5

BACKTRACE

FILE: include/db/mysql.php
LINE: 173
CALL: dbal->sql_error()

FILE: include/functions.php
LINE: 1773
CALL: dbal_mysql->sql_query()

FILE: index.php
LINE: 409
CALL: stdfoot()


Код: Выделить всё

[TB Dev SZ Edition Debug] PHP Notice: in file /include/sessions.php on line 1160: Undefined index: may_short
[TB Dev SZ Edition Debug] PHP Notice: in file /include/functions.php on line 1463: Undefined index: user_rank_id
[TB Dev SZ Edition Debug] PHP Notice: in file /include/functions.php on line 1481: Undefined index: user_reputation_level
[TB Dev SZ Edition Debug] PHP Notice: in file /include/functions.php on line 1482: Undefined index: user_reputation
[TB Dev SZ Edition Debug] PHP Notice: in file /include/functions.php on line 1690: Cannot modify header information - headers already sent by (output started at /include/functions.php:237)
 

Код: Выделить всё

QL ERROR [ mysql4 ]

Table 'crete1_nafania.tags' doesn't exist [1146]

SQL

SELECT tag_name, SUM(tag_count) AS tag_count FROM tags GROUP BY tag_name ORDER BY tag_count DESC LIMIT 30

BACKTRACE

FILE: include/db/mysql.php
LINE: 173
CALL: dbal->sql_error()

FILE: include/db/mysql.php
LINE: 220
CALL: dbal_mysql->sql_query()

FILE: include/db/dbal.php
LINE: 162
CALL: dbal_mysql->_sql_query_limit()

FILE: browse.php
LINE: 409
CALL: dbal->sql_query_limit()

I believe it is nothing important, some missing tables. do i need to add them by hand from your SQL ?
Again thanks for your help
PS- sorry for my english - no russian here

This converter converts only to 0.3.3 version.
Tags is from svn version.
You must use base 0.3.3 version to converter working and after converting you must update to svn version.

hello again
sorry for the trouble.,. where do i get 3.3 version from

EDIT: GOT IT

Thanks again

Hello,

I successfully converted my database into SZ and i love it!
I can use usernames, i can see greek i can see my torrents, My forums are in place Everything is ok.
Only

template->_tpl_load_file(): File ./templates/main/../upload_templates/27.html does not exist or is empty
template->_tpl_load_file(): File ./templates/main/../upload_templates/25.html does not exist or is empty
template->_tpl_load_file(): File ./templates/main/../upload_templates/19.html does not exist or is empty
etc ..
how can i fix this? am i missing files?

Furthermore when trying to upload download an existing torrent it says peer select error ( i am using the files and DB in a different webserver than the original site )

template->_tpl_load_file(): File ./templates/main/../upload_templates/27.html does not exist or is empty
template->_tpl_load_file(): File ./templates/main/../upload_templates/25.html does not exist or is empty
template->_tpl_load_file(): File ./templates/main/../upload_templates/19.html does not exist or is empty
etc ..

Furthermore when trying to upload download an existing torrent it says peer select error ( i am using the files and DB in a different webserver than the original site )

Converter not fully convert data and db or you don't do this.

You must run converter secondly on fresh your torrentstrike db