pragmaMx Support Forum

Archive => eBoard => veraltete bzw. unsupportete Systeme und Module => Alt Archive => eBoard FAQ - english / englisch => Thema gestartet von: tequila am 02 Januar 2003, 14:52:48

Titel: SQL-error after updating the VKP-Mxxx to SP1
Beitrag von: tequila am 02 Januar 2003, 14:52:48
Hello.
I just updated my VKP-Mxxx to the SP1, now I get a lot of SQL-errors when I use the Your_Account module:

error in sql-statement: mysql_query, err-no: 1146
qry: select count(tid) from nuke_eBoard_threads where author='Lucky'
description: Table 'dab_club_de.nuke_eBoard_threads' doesn't exist

error in sql-statement: mysql_fetch_array, err-no: 1146
description: Table 'dab_club_de.nuke_eBoard_threads' doesn't exist

error in sql-statement: mysql_query, err-no: 1146
qry: select count(pid) from nuke_eBoard_posts where author='Lucky'
description: Table 'dab_club_de.nuke_eBoard_posts' doesn't exist

error in sql-statement: mysql_fetch_array, err-no: 1146
description: Table 'dab_club_de.nuke_eBoard_posts' doesn't exist

How can I fix this?
Titel: Re: SQL-error after updating the VKP-Mxxx to SP1
Beitrag von: tequila am 02 Januar 2003, 14:56:14
Than you have upgraded from the old VKP 5.5 to the VKP-Mxxx and used the XForum before.

In this case the table names are not eBoard, they are still xmb.

Please open the following file with an editor:

/modules/Your_Account/userpoints.php

and find the next two entries and change them as shows:

_eBoard_threads --> _xmb_threads
_eBoard_posts --> _xmb_posts

This only affects users of the VKP-Mxxx which have upgraded from the VKP 5.5!