ECC Crash after Update 00622

[zoopcrewkid]

Hi I updated ECC today with Update 00622. Now I can not get the program to launch.

I have attached the diag log.

[zoopcrewkid]

Capture.JPG (13.97 KiB) Viewed 1120 times

[Shando]

Hi all,

I'm getting the same issue.

Diagnostics File attached.

Regards

Shando

[Phoenix]

Hi All,

A new install 1.21 works PHEW!!

But i may have found the problem, it seems the DATABASE is not getting updated due to new ECC version string, so could you try the following:

edit the file: ecc-system\manager\cEccUpdate.php (with notepad++)

And change the line:

Code: Select all

case $eccDbVersion < '1.2003':

to

Code: Select all

case $eccDbVersion < '1.2102':

Start ECC, let me know if it worked!

[Shando]

Hi Phoenix,

No, still crashes out the same

Regards

Shando

[Phoenix]

Hi Shando,

Strange, i will post some more later this evening! to look and test... (i am at my work now..., not handy to post screenshots etc...)

Ps. For now update 00622 has been disabled for eccUpdate...

[Shando]

Hi Phoenix,

No worries, will give me something to look forward to in the morning here

Regards

Shando

[zoopcrewkid]

Awesome thank you

[Phoenix]

Hi All,

It seems i cannot recreate this bug!!

I've used v1.20 added some roms and metadata, then updated to v1.21 with eccUpdate, all with no problems and all work fine...ECC starts up...no error...

It also seems no PHP error, and there is no error listed in the diagnose files....so wierd....

1. Have you set the location/path to the ECC database manually?

2. So could you look something up?

Open the database editor:

eccdatabase_01.png (14.14 KiB) Viewed 1099 times

And look if these 3 columns exist:

eccdatabase_02.png (15.94 KiB) Viewed 1099 times

Let me know!

[zoopcrewkid]

So ECC will not launch at all. The issue is with the latest version reading the database. I downloaded a clean version and launched it and it worked fine. When I added my database to emuControlCenter-master\ecc-system\database, the program crashes. It tries to start up for a minute then I get the following error.

Capture.JPG (15.98 KiB) Viewed 1098 times

. My current database is about 700 Mb.

[zoopcrewkid]

If I remove the database path from the ecc_general.ini then ecc launches, but none of my roms show.

[Shando]

Hi Phoenix,

I renamed my database to "_160916_old" and started up ecc.

ECC started fine & received an update but with an empty database. I checked my old database in the SQLite Browser and the three columns are all there.

I then deleted the new blank database and renamed my old one back. Restarted ECC and it crashed again, so there is obviously some problem with using/reading old databases

My database is almost 500MB in size.

HTH

Regards

Shando

PS: I also noticed that even though ECC closed after the error, CLI is still running in Task Manager (~20% CPU usage, ~27MB RAM and 0.1MB/s DISK)

[Phoenix]

Hi Shando,

Oh lol, sorry ofcourse ECC isn't starting up....you can open the database viewer with

Code: Select all

ecc-core\thirdparty\sqlitebrowser\sqlitebrowser.exe

Then open the ECC database...
Let me know if the columns exist...


Ps. There is a PHP update script to update the database in the last version, but not tested on 500MB+ sizes!!

[Phoenix]

Something to try...

Update ECC database manually

Please make a backup of your ECC database....

Open the SQLlite editor and in the QUERY TAB insert these code pieces ONE-BY-ONE and press execute, all should return NO ERROR per execxuted statement in the FIELD, if there is an error, then we got the error...

1. first create an TEMP-Table like the old one!

Code: Select all

CREATE TABLE [mdata_TEMP] (
[id] INTEGER  PRIMARY KEY NOT NULL,
[eccident] VARCHAR(8)  NULL,
[crc32] VARCHAR(8)  NULL,
[name] VARCHAR(255)  NULL,
[extension] VARCHAR(8)  NULL,
[info] VARCHAR(128)  NULL,
[info_id] VARCHAR(32)  NULL,
[running] INTEGER  NULL,
[bugs] INTEGER  NULL,
[trainer] INTEGER  NULL,
[intro] INTEGER  NULL,
[usermod] INTEGER  NULL,
[freeware] INTEGER  NULL,
[multiplayer] INTEGER  NULL,
[netplay] INTEGER  NULL,
[year] VARCHAR(4)  NULL,
[usk] INTEGER  NULL,
[storage] INTEGER  NULL,
[rating] INTEGER DEFAULT '0' NULL,
[category] INTEGER  NULL,
[category_base] INTEGER  NULL,
[creator] VARCHAR(128)  NULL,
[publisher] VARCHAR(128)  NULL,
[programmer] VARCHAR(128)  NULL,
[musican] VARCHAR(128) NULL,
[graphics] VARCHAR(128) NULL,
[media_type] INTEGER  NULL,
[media_current] INTEGER  NULL,
[media_count] INTEGER  NULL,
[region] INTEGER  NULL,
[dump_type] INTEGER  NULL,
[cdate] INTEGER  NULL,
[uexport] VARCHAR(15)  NULL,
[filesize] INTEGER  NULL
)

PRESS EXECUTE

2. then insert old data into TEMP-Table

Code: Select all

INSERT INTO [mdata_TEMP] SELECT * FROM [mdata];

PRESS EXECUTE

3. Then drop original table

Code: Select all

DROP TABLE [mdata];

PRESS EXECUTE

4. create new table structure

Code: Select all

CREATE TABLE [mdata] (
[id] INTEGER  PRIMARY KEY NOT NULL,
[eccident] VARCHAR(8)  NULL,
[crc32] VARCHAR(8)  NULL,
[name] VARCHAR(255)  NULL,
[extension] VARCHAR(8)  NULL,
[info] VARCHAR(128)  NULL,
[info_id] VARCHAR(32)  NULL,
[running] INTEGER  NULL,
[bugs] INTEGER  NULL,
[trainer] INTEGER  NULL,
[intro] INTEGER  NULL,
[usermod] INTEGER  NULL,
[freeware] INTEGER  NULL,
[multiplayer] INTEGER  NULL,
[netplay] INTEGER  NULL,
[year] VARCHAR(4)  NULL,
[usk] INTEGER  NULL,
[storage] INTEGER  NULL,
[rating] INTEGER DEFAULT '0' NULL,
[category] INTEGER  NULL,
[category_base] INTEGER  NULL,
[creator] VARCHAR(128)  NULL,
[publisher] VARCHAR(128)  NULL,
[perspective] INTEGER  NULL,
[visual] INTEGER  NULL,
[description] VARCHAR(4096)  NULL,
[programmer] VARCHAR(128)  NULL,
[musican] VARCHAR(128) NULL,
[graphics] VARCHAR(128) NULL,
[media_type] INTEGER  NULL,
[media_current] INTEGER  NULL,
[media_count] INTEGER  NULL,
[region] INTEGER  NULL,
[dump_type] INTEGER  NULL,
[cdate] INTEGER  NULL,
[uexport] VARCHAR(15)  NULL,
[filesize] INTEGER  NULL
)

PRESS EXECUTE

5. insert old data into new table

Code: Select all

INSERT INTO [mdata]
(
[id],
[eccident],
[crc32],
[name],
[extension],
[info],
[info_id],
[running],
[bugs],
[trainer],
[intro],
[usermod],
[freeware],
[multiplayer],
[netplay],
[year],
[usk],
[storage],
[rating],
[category],
[category_base],
[creator],
[publisher],
[programmer],
[musican],
[graphics],
[media_type],
[media_current],
[media_count],
[region],
[dump_type],
[cdate],
[uexport],
[filesize]
)
SELECT * FROM [mdata_TEMP];

PRESS EXECUTE

6. drop TEMP-Table

Code: Select all

DROP TABLE [mdata_TEMP];

PRESS EXECUTE

7. commit changes

Code: Select all

COMMIT;

PRESS EXECUTE

Nevertheless...SAVE the DATABASE!

Try to start ECC...

[Shando]

Hi Again,

When I run Step 2 I get the following error:

table mdata_TEMP has 34 columns but 37 values were supplied

I guess this means that my dB has already been updated correctly??

Regards

Shando

BTW, this is the output I get from running a debugger on the CLI (32 bit) Process (don't know if it will help or not):

Code: Select all

'php.exe' (Win32): Loaded 'G:\emuControlCenter\ecc-core\php-gtk2\php.exe'. Module was built without symbols.
'php.exe' (Win32): Loaded 'C:\WINDOWS\SysWOW64\ntdll.dll'. Cannot find or open the PDB file.
'php.exe' (Win32): Loaded 'C:\WINDOWS\SysWOW64\kernel32.dll'. Cannot find or open the PDB file.
'php.exe' (Win32): Loaded 'C:\WINDOWS\SysWOW64\KernelBase.dll'. Cannot find or open the PDB file.
'php.exe' (Win32): Loaded 'C:\WINDOWS\SysWOW64\msvcrt.dll'. Cannot find or open the PDB file.
'php.exe' (Win32): Loaded 'D:3\emuControlCenter\ecc-core\php-gtk2\php5.dll'. Module was built without symbols.
'php.exe' (Win32): Loaded 'C:\WINDOWS\SysWOW64\oleaut32.dll'. Cannot find or open the PDB file.
'php.exe' (Win32): Loaded 'C:\WINDOWS\SysWOW64\combase.dll'. Cannot find or open the PDB file.
'php.exe' (Win32): Loaded 'C:\WINDOWS\SysWOW64\rpcrt4.dll'. Cannot find or open the PDB file.
'php.exe' (Win32): Loaded 'C:\WINDOWS\SysWOW64\sspicli.dll'. Cannot find or open the PDB file.
'php.exe' (Win32): Loaded 'C:\WINDOWS\SysWOW64\cryptbase.dll'. Cannot find or open the PDB file.
'php.exe' (Win32): Loaded 'C:\WINDOWS\SysWOW64\bcryptprimitives.dll'. Cannot find or open the PDB file.
'php.exe' (Win32): Loaded 'C:\WINDOWS\SysWOW64\sechost.dll'. Cannot find or open the PDB file.
'php.exe' (Win32): Loaded 'C:\WINDOWS\SysWOW64\ole32.dll'. Cannot find or open the PDB file.
'php.exe' (Win32): Loaded 'C:\WINDOWS\SysWOW64\gdi32.dll'. Cannot find or open the PDB file.
'php.exe' (Win32): Loaded 'C:\WINDOWS\SysWOW64\user32.dll'. Cannot find or open the PDB file.
'php.exe' (Win32): Loaded 'C:\WINDOWS\SysWOW64\odbc32.dll'. Cannot find or open the PDB file.
'php.exe' (Win32): Loaded 'C:\WINDOWS\SysWOW64\advapi32.dll'. Cannot find or open the PDB file.
'php.exe' (Win32): Loaded 'C:\WINDOWS\SysWOW64\ws2_32.dll'. Cannot find or open the PDB file.
'php.exe' (Win32): Loaded 'C:\WINDOWS\SysWOW64\nsi.dll'. Cannot find or open the PDB file.
'php.exe' (Win32): Loaded 'C:\WINDOWS\SysWOW64\dpapi.dll'. Cannot find or open the PDB file.
'php.exe' (Win32): Loaded 'C:\WINDOWS\SysWOW64\imm32.dll'. Cannot find or open the PDB file.
'php.exe' (Win32): Loaded 'C:\WINDOWS\SysWOW64\msctf.dll'. Cannot find or open the PDB file.
'php.exe' (Win32): Loaded 'D:3\emuControlCenter\ecc-core\php-gtk2\ext\php_gtk2.dll'. Module was built without symbols.
'php.exe' (Win32): Loaded 'D:3\emuControlCenter\ecc-core\php-gtk2\libatk-1.0-0.dll'. Module was built without symbols.
'php.exe' (Win32): Loaded 'D:3\emuControlCenter\ecc-core\php-gtk2\libglib-2.0-0.dll'. Module was built without symbols.
'php.exe' (Win32): Loaded 'D:3\emuControlCenter\ecc-core\php-gtk2\libgobject-2.0-0.dll'. Module was built without symbols.
'php.exe' (Win32): Loaded 'D:3\emuControlCenter\ecc-core\php-gtk2\libpango-1.0-0.dll'. Module was built without symbols.
'php.exe' (Win32): Loaded 'D:3\emuControlCenter\ecc-core\php-gtk2\libgdk_pixbuf-2.0-0.dll'. Module was built without symbols.
'php.exe' (Win32): Loaded 'C:\WINDOWS\SysWOW64\shell32.dll'. Cannot find or open the PDB file.
'php.exe' (Win32): Loaded 'C:\WINDOWS\SysWOW64\windows.storage.dll'. Cannot find or open the PDB file.
'php.exe' (Win32): Loaded 'C:\WINDOWS\SysWOW64\shlwapi.dll'. Cannot find or open the PDB file.
'php.exe' (Win32): Loaded 'C:\WINDOWS\SysWOW64\kernel.appcore.dll'. Cannot find or open the PDB file.
'php.exe' (Win32): Loaded 'C:\WINDOWS\SysWOW64\SHCore.dll'. Cannot find or open the PDB file.
'php.exe' (Win32): Loaded 'C:\WINDOWS\SysWOW64\powrprof.dll'. Cannot find or open the PDB file.
'php.exe' (Win32): Loaded 'C:\WINDOWS\SysWOW64\profapi.dll'. Cannot find or open the PDB file.
'php.exe' (Win32): Loaded 'D:3\emuControlCenter\ecc-core\php-gtk2\libgdk-win32-2.0-0.dll'. Module was built without symbols.
'php.exe' (Win32): Loaded 'D:3\emuControlCenter\ecc-core\php-gtk2\libgtk-win32-2.0-0.dll'. Module was built without symbols.
'php.exe' (Win32): Loaded 'D:3\emuControlCenter\ecc-core\php-gtk2\intl.dll'. Module was built without symbols.
'php.exe' (Win32): Loaded 'D:3\emuControlCenter\ecc-core\php-gtk2\libgmodule-2.0-0.dll'. Module was built without symbols.
'php.exe' (Win32): Loaded 'D:3\emuControlCenter\ecc-core\php-gtk2\libcairo-2.dll'. Module was built without symbols.
'php.exe' (Win32): Loaded 'C:\WINDOWS\SysWOW64\comdlg32.dll'. Cannot find or open the PDB file.
'php.exe' (Win32): Loaded 'D:3\emuControlCenter\ecc-core\php-gtk2\libpangocairo-1.0-0.dll'. Module was built without symbols.
'php.exe' (Win32): Loaded 'C:\WINDOWS\SysWOW64\winspool.drv'. Cannot find or open the PDB file.
'php.exe' (Win32): Loaded 'D:3\emuControlCenter\ecc-core\php-gtk2\libpng13.dll'. Module was built without symbols.
'php.exe' (Win32): Loaded 'C:\WINDOWS\WinSxS\x86_microsoft.windows.common-controls_6595b64144ccf1df_5.82.10240.16384_none_49c02355cf03478c\comctl32.dll'. Cannot find or open the PDB file.
'php.exe' (Win32): Loaded 'C:\WINDOWS\SysWOW64\msimg32.dll'. Cannot find or open the PDB file.
'php.exe' (Win32): Loaded 'D:3\emuControlCenter\ecc-core\php-gtk2\zlib1.dll'. Module was built without symbols.
'php.exe' (Win32): Loaded 'D:3\emuControlCenter\ecc-core\php-gtk2\libpangowin32-1.0-0.dll'. Module was built without symbols.
'php.exe' (Win32): Loaded 'C:\WINDOWS\SysWOW64\bcrypt.dll'. Cannot find or open the PDB file.
'php.exe' (Win32): Loaded 'D:3\emuControlCenter\ecc-core\php-gtk2\ext\php_pdo.dll'. Module was built without symbols.
'php.exe' (Win32): Loaded 'D:3\emuControlCenter\ecc-core\php-gtk2\ext\php_pdo_sqlite.dll'. Module was built without symbols.
'php.exe' (Win32): Loaded 'D:3\emuControlCenter\ecc-core\php-gtk2\ext\php_sqlite.dll'. Module was built without symbols.
'php.exe' (Win32): Loaded 'D:3\emuControlCenter\ecc-core\php-gtk2\ext\php_gd2.dll'. Module was built without symbols.
'php.exe' (Win32): Loaded 'D:3\emuControlCenter\ecc-core\php-gtk2\ext\php_zip.dll'. Module was built without symbols.
'php.exe' (Win32): Loaded 'D:3\emuControlCenter\ecc-core\php-gtk2\ext\php_win32std.dll'. Module was built without symbols.
'php.exe' (Win32): Loaded 'C:\WINDOWS\SysWOW64\winmm.dll'. Cannot find or open the PDB file.
'php.exe' (Win32): Loaded 'C:\WINDOWS\SysWOW64\winmmbase.dll'. Cannot find or open the PDB file.
'php.exe' (Win32): Loaded 'C:\WINDOWS\SysWOW64\cfgmgr32.dll'. Cannot find or open the PDB file.
'php.exe' (Win32): Loaded 'C:\WINDOWS\SysWOW64\devobj.dll'. Cannot find or open the PDB file.
'php.exe' (Win32): Loaded 'C:\WINDOWS\SysWOW64\uxtheme.dll'. Cannot find or open the PDB file.
'php.exe' (Win32): Loaded 'D:3\emuControlCenter\ecc-core\php-gtk2\ext\php_gtk_libglade2.dll'. Module was built without symbols.
'php.exe' (Win32): Loaded 'D:3\emuControlCenter\ecc-core\php-gtk2\libglade-2.0-0.dll'. Module was built without symbols.
'php.exe' (Win32): Loaded 'D:3\emuControlCenter\ecc-core\php-gtk2\libxml2.dll'. Module was built without symbols.
'php.exe' (Win32): Loaded 'D:3\emuControlCenter\ecc-core\php-gtk2\iconv.dll'. Module was built without symbols.
'php.exe' (Win32): Loaded 'C:\WINDOWS\SysWOW64\wsock32.dll'. Cannot find or open the PDB file.
'php.exe' (Win32): Loaded 'C:\WINDOWS\SysWOW64\clbcatq.dll'. Cannot find or open the PDB file.
'php.exe' (Win32): Loaded 'C:\WINDOWS\SysWOW64\scrrun.dll'. Cannot find or open the PDB file.
'php.exe' (Win32): Loaded 'C:\WINDOWS\SysWOW64\version.dll'. Cannot find or open the PDB file.
'php.exe' (Win32): Loaded 'C:\WINDOWS\SysWOW64\sxs.dll'. Cannot find or open the PDB file.
'php.exe' (Win32): Loaded 'D:3\emuControlCenter\ecc-core\php-gtk2\lib\gtk-2.0\2.10.0\engines\libpixmap.dll'. Module was built without symbols.
'php.exe' (Win32): Loaded 'C:\WINDOWS\SysWOW64\usp10.dll'. Cannot find or open the PDB file.
'php.exe' (Win32): Loaded 'D:3\emuControlCenter\ecc-core\php-gtk2\lib\gtk-2.0\2.10.0\loaders\libpixbufloader-png.dll'. Module was built without symbols.
The thread 0xac4c has exited with code 0 (0x0).

[Phoenix]

It seems you have wierd NON UTF-8 characters in the database....or something, seems like a language code table issue...

Could you verify if the columns already exist in the mdata table?, start the database program manually like described above...

[Shando]

You could very well be right

I've just exported the table from SQLite Browser and I can already see some strange characters when I open it in Excel using UTF-8 encoding! If I open in Code Page 1252 (Windows Western Europe) the characters appear fine.

I have quite a few Russian & Spanish games for the ZX Spectrum and many Japanese games for various systems.

Is there an easy way to clean up the dB so that it complies with UTF-8??

Shando

PS: The file name displays correctly in SQLite Browser

[Phoenix]

Well i really don't know if it's the database tables or PHP compiled multibyte-setting thingy...

Could you ZIP your DB and upload it somewhere?, so i could experiment with it?

[zoopcrewkid]

I can send you a copy of my database via secure transfer. What email address should I use?

[Phoenix]

use phoenixinteractive -at- hotmail -dot- com