Восстановление игр после ребилда базы данных

kamol · 24.02.2020, 00:02

лог

Processing table: tbl_appbrowse_0495611172
        Processing GameID: CUSA00002... Completed 40301101056
        Processing GameID: CUSA00004... Completed 23806410752
        Processing GameID: CUSA00265... Completed 181600256
        Processing GameID: CUSA00377... Completed 5585174528
        Processing GameID: CUSA00411... Completed 44755845120
        Processing GameID: CUSA00434... Completed 21665284096
        Processing GameID: CUSA00755... Completed 88735744
        Processing GameID: CUSA00897... Completed 10055909376
        Processing GameID: CUSA01154... Completed 26972979200
        Processing GameID: CUSA01608... Completed 394657792
        Processing GameID: CUSA01627... Completed 8757706752
        Processing GameID: CUSA01661... Completed 3478388736
        Processing GameID: CUSA02344... Completed 43569643520
        Processing GameID: CUSA03173... Completed 31351046144
        Processing GameID: CUSA03318... Completed 5822742528
        Processing GameID: CUSA03589... Completed 40241070080
        Processing GameID: CUSA03745... Completed 12874285056
        Processing GameID: CUSA03991... Completed 16043212800
        Processing GameID: CUSA04295... Completed 21890269184
        Processing GameID: CUSA04480... Completed 36912889856
        Processing GameID: CUSA04529... Completed 47596896256
        Processing GameID: CUSA04865... Completed 633339904
        Processing GameID: CUSA05486... Completed 31869829120
        Processing GameID: CUSA05588... Completed 975241216
        Processing GameID: CUSA05848... Completed 27715043328
        Processing GameID: CUSA05951... Completed 1836908544
        Processing GameID: CUSA06014... Completed 40884109312
        Processing GameID: CUSA07123... Completed 39266287616
        Processing GameID: CUSA07412... Completed 38388826112
        Processing GameID: CUSA07439... Completed 23391764480
Traceback (most recent call last):
  File "fix_db.py", line 81, in <module>
  File "fix_db.py", line 44, in get_game_info_by_id
  File "ftplib.py", line 636, in size
  File "ftplib.py", line 273, in sendcmd
  File "ftplib.py", line 246, in getresp
ftplib.error_perm: 550 The file doesn't exist.
[2916] Failed to execute script fix_db
        Processing GameID: CUSA09564...
C:\Users\Askarjom>

a na ployke pusto

kamol добавил 23.02.2020 в 23:20
mojet eshe kakoy vriant est? bez ftp prosto pkg faylom. zaranee spasibo!

cherez python toje ne pomoglo

Логи

C:\Users\Askarjom\Desktop>py fix_db.py 192.168.1.111
["'CUSA03173'", "'CUSA05848'", "'CUSA07412'", "'CUSA00411'", "'CUSA10213'", "'CU
SA00897'", "'CUSA01154'", "'CUSA03589'", "'CUSA06014'", "'CUSA04865'", "'CUSA002
65'", "'CUSA00755'", "'CUSA05951'", "'CUSA00002'", "'CUSA00004'", "'CUSA09564'",
 "'CUSA03991'", "'CUSA07439'", "'CUSA01661'", "'CUSA03745'", "'CUSA01627'", "'CU
SA03318'", "'CUSA00377'", "'CUSA01608'", "'CUSA00434'", "'CUSA05486'", "'CUSA071
23'", "'CUSA05588'", "'CUSA04480'", "'CUSA09643'", "'CUSA04529'", "'CUSA02344'",
 "'CUSA04295'"]
Processing table: tbl_appbrowse_0495611172
        Processing GameID: CUSA00002... Completed 40301101056
        Processing GameID: CUSA00004... Completed 23806410752
        Processing GameID: CUSA00265... Completed 181600256
        Processing GameID: CUSA00377... Completed 5585174528
        Processing GameID: CUSA00411... Completed 44755845120
        Processing GameID: CUSA00434... Completed 21665284096
        Processing GameID: CUSA00755... Completed 88735744
        Processing GameID: CUSA00897... Completed 10055909376
        Processing GameID: CUSA01154... Completed 26972979200
        Processing GameID: CUSA01608... Completed 394657792
        Processing GameID: CUSA01627... Completed 8757706752
        Processing GameID: CUSA01661... Completed 3478388736
        Processing GameID: CUSA02344... Completed 43569643520
        Processing GameID: CUSA03173... Completed 31351046144
        Processing GameID: CUSA03318... Completed 5822742528
        Processing GameID: CUSA03589... Completed 40241070080
        Processing GameID: CUSA03745... Completed 12874285056
        Processing GameID: CUSA03991... Completed 16043212800
        Processing GameID: CUSA04295... Completed 21890269184
        Processing GameID: CUSA04480... Completed 36912889856
        Processing GameID: CUSA04529... Completed 47596896256
        Processing GameID: CUSA04865... Completed 633339904
        Processing GameID: CUSA05486... Completed 31869829120
        Processing GameID: CUSA05588... Completed 975241216
        Processing GameID: CUSA05848... Completed 27715043328
        Processing GameID: CUSA05951... Completed 1836908544
        Processing GameID: CUSA06014... Completed 40884109312
        Processing GameID: CUSA07123... Completed 39266287616
        Processing GameID: CUSA07412... Completed 38388826112
        Processing GameID: CUSA07439... Completed 23391764480
        Processing GameID: CUSA09564... Traceback (most recent call last):
  File "fix_db.py", line 81, in <module>
    cusa = get_game_info_by_id(GameID)
  File "fix_db.py", line 44, in get_game_info_by_id
    info[GameID].size = ftp.size("/user/app/%s/app.pkg" % GameID)
  File "C:\Users\Askarjom\AppData\Local\Programs\Python\Python38-32\lib\ftplib.p
y", line 619, in size
    resp = self.sendcmd('SIZE ' + filename)
  File "C:\Users\Askarjom\AppData\Local\Programs\Python\Python38-32\lib\ftplib.p
y", line 275, in sendcmd
    return self.getresp()
  File "C:\Users\Askarjom\AppData\Local\Programs\Python\Python38-32\lib\ftplib.p
y", line 248, in getresp
    raise error_perm(resp)
ftplib.error_perm: 550 The file doesn't exist.

C:\Users\Askarjom\Desktop>

kamol добавил 24.02.2020 в 00:02
u menya vopros kak ti sdelal logout ne zakrivaya brawzer? i eshe u tebya krutilas` zagruzka na ps4 vse vremya ili posle zapuska ftp otkrilos` okno brawzera?

in1975 · 24.02.2020, 02:21

kamol, тебе вроде ясно написало что по игре CUSA09564 нету файлов. Программа споткнулась и не сработала до конца.

И не надо писать транслитом, это нарушение правил.

maxxxpull · 17.10.2020, 00:00

Здравствуйте, подскажите пожалуйста, в чем косяк?
Processing table: tbl_appbrowse_0383300084
Processing GameID: CUSA00062... Completed 2113142784
Processing GameID: CUSA00434... Completed 21665284096
Processing GameID: CUSA01073... Completed 27477409792
Processing GameID: CUSA03173... Completed 31351111680
Processing GameID: CUSA03745... Completed 12874219520
Processing GameID: CUSA05159... Completed 2986082304
Processing GameID: CUSA06534... Completed 18901172224
Processing GameID: CUSA07399... Completed 22718709760
Processing GameID: CUSA07412... Completed 38388826112
Processing GameID: CUSA07670... Completed 40024539136
Processing GameID: CUSA08004... Completed 16980377600
Processing GameID: CUSA08809... Completed 13567262720
Processing GameID: CUSA09176... Completed 37768200192
Processing GameID: CUSA11995... Completed 47383707648
Processing GameID: CUSA12085... Completed 31342788608
Processing GameID: CUSA12607... Completed 46831501312
Processing GameID: CUSA15447... Completed 30552162304
Processing GameID: CUSA15546... Completed 42665967616
Traceback (most recent call last):
File "fix_db.py", line 90, in <module>
sqlite3.OperationalError: table tbl_appbrowse_0383300084 has 53 columns but 47 values were supplied
[14540] Failed to execute script fix_db

maxxxpull добавил 16.10.2020 в 23:56
Нашли ответ? У меня тоже самое...

maxxxpull добавил 16.10.2020 в 23:57
dj-xrom, Вы нашли ответ на эту ошибку? или забили?

maxxxpull добавил 17.10.2020 в 00:00
in1975, Извиняюсь за спам, не знаю как тут писать...Вы можете подсказать, как решить проблему выше?

in1975 · 17.10.2020, 17:49

maxxxpull, таблица tbl_appbrowse_0383300084 имеет 53 столбца, но было предоставлено 47 значений.

Чем я могу помочь?

Nikita757 · 15.11.2020, 12:17

Сообщение от maxxxpull

Здравствуйте, подскажите пожалуйста, в чем косяк?
Processing table: tbl_appbrowse_0383300084
Processing GameID: CUSA00062... Completed 2113142784
Processing GameID: CUSA00434... Completed 21665284096
Processing GameID: CUSA01073... Completed 27477409792
Processing GameID: CUSA03173... Completed 31351111680
Processing GameID: CUSA03745... Completed 12874219520
Processing GameID: CUSA05159... Completed 2986082304
Processing GameID: CUSA06534... Completed 18901172224
Processing GameID: CUSA07399... Completed 22718709760
Processing GameID: CUSA07412... Completed 38388826112
Processing GameID: CUSA07670... Completed 40024539136
Processing GameID: CUSA08004... Completed 16980377600
Processing GameID: CUSA08809... Completed 13567262720
Processing GameID: CUSA09176... Completed 37768200192
Processing GameID: CUSA11995... Completed 47383707648
Processing GameID: CUSA12085... Completed 31342788608
Processing GameID: CUSA12607... Completed 46831501312
Processing GameID: CUSA15447... Completed 30552162304
Processing GameID: CUSA15546... Completed 42665967616
Traceback (most recent call last):
File "fix_db.py", line 90, in <module>
sqlite3.OperationalError: table tbl_appbrowse_0383300084 has 53 columns but 47 values were supplied
[14540] Failed to execute script fix_db

maxxxpull добавил 16.10.2020 в 23:56
Нашли ответ? У меня тоже самое...

maxxxpull добавил 16.10.2020 в 23:57
dj-xrom, Вы нашли ответ на эту ошибку? или забили?

maxxxpull добавил 17.10.2020 в 00:00
in1975, Извиняюсь за спам, не знаю как тут писать...Вы можете подсказать, как решить проблему выше?

такая же ошибка, нашел рещение?

leviafan_83 · 15.11.2020, 17:10

Nikita757, выйди из учетки и поновой войди

Slim_Shady · 15.01.2021, 18:57

Слетели все игры, сейчас попробую

PaSoul · 19.05.2021, 22:47

Привет.
Я бы в шапку добавил ещё информацию, как подключить ps4 к ПК по lan. Для ps3 есть хорошая инструкция, можно сделать по аналогии.

PaSoul добавил 19.05.2021 в 22:47
Забыл ссылку на инструкцию: https://www.pspx.ru/forum/showthread...22#cabnorouter

in1975 · 21.05.2021, 12:25

PaSoul, в общей инструкции в разделе пс4 это есть.