pragmaMx Support Forum

pragmaMx => Installation & Update => Thema gestartet von: bigfu am 23 September 2003, 14:06:51

Titel: Hilfe
Beitrag von: bigfu am 23 September 2003, 14:06:51
ich hab zu hause des 2.0 an meine bedürfnisse angepasst was auch aller super klappt.

Jetzt hab ich alle Daten hochgeladen und die Datenbank aus localhost auf die im www übertragen nur leider bekomme ich folgende fehler.
 

Error sql_query():
qry: SELECT COUNT(tid) as nbsites, SUM(views) as totalus FROM mx_eBoard_threads
descr: Table 'usr_web7_1.mx_eBoard_threads' doesn't exist ( mysql 1146 )
details:

                     file: /home/www/web7/html/blocks/block-eBoard_mxCenter.php # line: 171, cmd: sql_query(),
                  file: /home/www/web7/html/ixed/ze/mx_api.php # line: 742, cmd: include(/home/www/web7/html/blocks/block-eBoard_mxCenter.php),
               file: /home/www/web7/html/ixed/ze/mx_system.php # line: 373, cmd: mxgetblockdata(/home/www/web7/html/blocks/block-eBoard_mxCenter.php),
            file: /home/www/web7/html/ixed/ze/mx_system.php # line: 576, cmd: mxgetallblocks(/home/www/web7/html/blocks/block-eBoard_mxCenter.php),
         file: /home/www/web7/html/themes/vkpMx-fisubice/theme.php # line: 122, cmd: blocks(/home/www/web7/html/blocks/block-eBoard_mxCenter.php),
      file: /home/www/web7/html/header.php # line:  94, cmd: themeheader(/home/www/web7/html/blocks/block-eBoard_mxCenter.php),
   file: /home/www/web7/html/modules/blank_Home/index.php # line:  35, cmd: include(/home/www/web7/html/blocks/block-eBoard_mxCenter.php, /home/www/web7/html/header.php),
file: /home/www/web7/html/index.php # line:  70, cmd: include_once(/home/www/web7/html/blocks/block-eBoard_mxCenter.php, /home/www/web7/html/header.php, /home/www/web7/html/modules/blank_Home/index.php),

Error sql_fetch_object():
descr: mysql_fetch_object(): supplied argument is not a valid MySQL result resource
details:

                     file: /home/www/web7/html/blocks/block-eBoard_mxCenter.php # line: 172, cmd: sql_fetch_object(),
                  file: /home/www/web7/html/ixed/ze/mx_api.php # line: 742, cmd: include(/home/www/web7/html/blocks/block-eBoard_mxCenter.php),
               file: /home/www/web7/html/ixed/ze/mx_system.php # line: 373, cmd: mxgetblockdata(/home/www/web7/html/blocks/block-eBoard_mxCenter.php),
            file: /home/www/web7/html/ixed/ze/mx_system.php # line: 576, cmd: mxgetallblocks(/home/www/web7/html/blocks/block-eBoard_mxCenter.php),
         file: /home/www/web7/html/themes/vkpMx-fisubice/theme.php # line: 122, cmd: blocks(/home/www/web7/html/blocks/block-eBoard_mxCenter.php),
      file: /home/www/web7/html/header.php # line:  94, cmd: themeheader(/home/www/web7/html/blocks/block-eBoard_mxCenter.php),
   file: /home/www/web7/html/modules/blank_Home/index.php # line:  35, cmd: include(/home/www/web7/html/blocks/block-eBoard_mxCenter.php, /home/www/web7/html/header.php),
file: /home/www/web7/html/index.php # line:  70, cmd: include_once(/home/www/web7/html/blocks/block-eBoard_mxCenter.php, /home/www/web7/html/header.php, /home/www/web7/html/modules/blank_Home/index.php),

Error sql_query():
qry: SELECT COUNT(pid) as nbposts FROM mx_eBoard_posts
descr: Table 'usr_web7_1.mx_eBoard_posts' doesn't exist ( mysql 1146 )
details:

                     file: /home/www/web7/html/blocks/block-eBoard_mxCenter.php # line: 175, cmd: sql_query(),
                  file: /home/www/web7/html/ixed/ze/mx_api.php # line: 742, cmd: include(/home/www/web7/html/blocks/block-eBoard_mxCenter.php),
               file: /home/www/web7/html/ixed/ze/mx_system.php # line: 373, cmd: mxgetblockdata(/home/www/web7/html/blocks/block-eBoard_mxCenter.php),
            file: /home/www/web7/html/ixed/ze/mx_system.php # line: 576, cmd: mxgetallblocks(/home/www/web7/html/blocks/block-eBoard_mxCenter.php),
         file: /home/www/web7/html/themes/vkpMx-fisubice/theme.php # line: 122, cmd: blocks(/home/www/web7/html/blocks/block-eBoard_mxCenter.php),
      file: /home/www/web7/html/header.php # line:  94, cmd: themeheader(/home/www/web7/html/blocks/block-eBoard_mxCenter.php),
   file: /home/www/web7/html/modules/blank_Home/index.php # line:  35, cmd: include(/home/www/web7/html/blocks/block-eBoard_mxCenter.php, /home/www/web7/html/header.php),
file: /home/www/web7/html/index.php # line:  70, cmd: include_once(/home/www/web7/html/blocks/block-eBoard_mxCenter.php, /home/www/web7/html/header.php, /home/www/web7/html/modules/blank_Home/index.php),

Error sql_fetch_object():
descr: mysql_fetch_object(): supplied argument is not a valid MySQL result resource
details:

                     file: /home/www/web7/html/blocks/block-eBoard_mxCenter.php # line: 176, cmd: sql_fetch_object(),
                  file: /home/www/web7/html/ixed/ze/mx_api.php # line: 742, cmd: include(/home/www/web7/html/blocks/block-eBoard_mxCenter.php),
               file: /home/www/web7/html/ixed/ze/mx_system.php # line: 373, cmd: mxgetblockdata(/home/www/web7/html/blocks/block-eBoard_mxCenter.php),
            file: /home/www/web7/html/ixed/ze/mx_system.php # line: 576, cmd: mxgetallblocks(/home/www/web7/html/blocks/block-eBoard_mxCenter.php),
         file: /home/www/web7/html/themes/vkpMx-fisubice/theme.php # line: 122, cmd: blocks(/home/www/web7/html/blocks/block-eBoard_mxCenter.php),
      file: /home/www/web7/html/header.php # line:  94, cmd: themeheader(/home/www/web7/html/blocks/block-eBoard_mxCenter.php),
   file: /home/www/web7/html/modules/blank_Home/index.php # line:  35, cmd: include(/home/www/web7/html/blocks/block-eBoard_mxCenter.php, /home/www/web7/html/header.php),
file: /home/www/web7/html/index.php # line:  70, cmd: include_once(/home/www/web7/html/blocks/block-eBoard_mxCenter.php, /home/www/web7/html/header.php, /home/www/web7/html/modules/blank_Home/index.php),

Error sql_query():
qry: SELECT COUNT(uid) as xusers FROM mx_eBoard_members
descr: Table 'usr_web7_1.mx_eBoard_members' doesn't exist ( mysql 1146 )
details:

                     file: /home/www/web7/html/blocks/block-eBoard_mxCenter.php # line: 179, cmd: sql_query(),
                  file: /home/www/web7/html/ixed/ze/mx_api.php # line: 742, cmd: include(/home/www/web7/html/blocks/block-eBoard_mxCenter.php),
               file: /home/www/web7/html/ixed/ze/mx_system.php # line: 373, cmd: mxgetblockdata(/home/www/web7/html/blocks/block-eBoard_mxCenter.php),
            file: /home/www/web7/html/ixed/ze/mx_system.php # line: 576, cmd: mxgetallblocks(/home/www/web7/html/blocks/block-eBoard_mxCenter.php),
         file: /home/www/web7/html/themes/vkpMx-fisubice/theme.php # line: 122, cmd: blocks(/home/www/web7/html/blocks/block-eBoard_mxCenter.php),
      file: /home/www/web7/html/header.php # line:  94, cmd: themeheader(/home/www/web7/html/blocks/block-eBoard_mxCenter.php),
   file: /home/www/web7/html/modules/blank_Home/index.php # line:  35, cmd: include(/home/www/web7/html/blocks/block-eBoard_mxCenter.php, /home/www/web7/html/header.php),
file: /home/www/web7/html/index.php # line:  70, cmd: include_once(/home/www/web7/html/blocks/block-eBoard_mxCenter.php, /home/www/web7/html/header.php, /home/www/web7/html/modules/blank_Home/index.php),

Error sql_fetch_object():
descr: mysql_fetch_object(): supplied argument is not a valid MySQL result resource
details:

                     file: /home/www/web7/html/blocks/block-eBoard_mxCenter.php # line: 180, cmd: sql_fetch_object(),
                  file: /home/www/web7/html/ixed/ze/mx_api.php # line: 742, cmd: include(/home/www/web7/html/blocks/block-eBoard_mxCenter.php),
               file: /home/www/web7/html/ixed/ze/mx_system.php # line: 373, cmd: mxgetblockdata(/home/www/web7/html/blocks/block-eBoard_mxCenter.php),
            file: /home/www/web7/html/ixed/ze/mx_system.php # line: 576, cmd: mxgetallblocks(/home/www/web7/html/blocks/block-eBoard_mxCenter.php),
         file: /home/www/web7/html/themes/vkpMx-fisubice/theme.php # line: 122, cmd: blocks(/home/www/web7/html/blocks/block-eBoard_mxCenter.php),
      file: /home/www/web7/html/header.php # line:  94, cmd: themeheader(/home/www/web7/html/blocks/block-eBoard_mxCenter.php),
   file: /home/www/web7/html/modules/blank_Home/index.php # line:  35, cmd: include(/home/www/web7/html/blocks/block-eBoard_mxCenter.php, /home/www/web7/html/header.php),
file: /home/www/web7/html/index.php # line:  70, cmd: include_once(/home/www/web7/html/blocks/block-eBoard_mxCenter.php, /home/www/web7/html/header.php, /home/www/web7/html/modules/blank_Home/index.php),

Error sql_query():
qry: SELECT thread.tid, thread.views, thread.subject, thread.lastpost, thread.dateline, thread.replies, thread.author, thread.icon, thread.fid, forum.name, forum.moderator, forum.private, forum.userlist FROM mx_eBoard_threads AS thread, mx_eBoard_forums AS forum WHERE forum.fid=thread.fid ORDER BY thread.lastpost Desc LIMIT 0, 10
descr: Table 'usr_web7_1.mx_eBoard_threads' doesn't exist ( mysql 1146 )
details:

                     file: /home/www/web7/html/blocks/block-eBoard_mxCenter.php # line: 216, cmd: sql_query(),
                  file: /home/www/web7/html/ixed/ze/mx_api.php # line: 742, cmd: include(/home/www/web7/html/blocks/block-eBoard_mxCenter.php),
               file: /home/www/web7/html/ixed/ze/mx_system.php # line: 373, cmd: mxgetblockdata(/home/www/web7/html/blocks/block-eBoard_mxCenter.php),
            file: /home/www/web7/html/ixed/ze/mx_system.php # line: 576, cmd: mxgetallblocks(/home/www/web7/html/blocks/block-eBoard_mxCenter.php),
         file: /home/www/web7/html/themes/vkpMx-fisubice/theme.php # line: 122, cmd: blocks(/home/www/web7/html/blocks/block-eBoard_mxCenter.php),
      file: /home/www/web7/html/header.php # line:  94, cmd: themeheader(/home/www/web7/html/blocks/block-eBoard_mxCenter.php),
   file: /home/www/web7/html/modules/blank_Home/index.php # line:  35, cmd: include(/home/www/web7/html/blocks/block-eBoard_mxCenter.php, /home/www/web7/html/header.php),
file: /home/www/web7/html/index.php # line:  70, cmd: include_once(/home/www/web7/html/blocks/block-eBoard_mxCenter.php, /home/www/web7/html/header.php, /home/www/web7/html/modules/blank_Home/index.php),

Error sql_fetch_row():
descr: mysql_fetch_row(): supplied argument is not a valid MySQL result resource
details:

                     file: /home/www/web7/html/blocks/block-eBoard_mxCenter.php # line: 219, cmd: sql_fetch_row(),
                  file: /home/www/web7/html/ixed/ze/mx_api.php # line: 742, cmd: include(/home/www/web7/html/blocks/block-eBoard_mxCenter.php),
               file: /home/www/web7/html/ixed/ze/mx_system.php # line: 373, cmd: mxgetblockdata(/home/www/web7/html/blocks/block-eBoard_mxCenter.php),
            file: /home/www/web7/html/ixed/ze/mx_system.php # line: 576, cmd: mxgetallblocks(/home/www/web7/html/blocks/block-eBoard_mxCenter.php),
         file: /home/www/web7/html/themes/vkpMx-fisubice/theme.php # line: 122, cmd: blocks(/home/www/web7/html/blocks/block-eBoard_mxCenter.php),
      file: /home/www/web7/html/header.php # line:  94, cmd: themeheader(/home/www/web7/html/blocks/block-eBoard_mxCenter.php),
   file: /home/www/web7/html/modules/blank_Home/index.php # line:  35, cmd: include(/home/www/web7/html/blocks/block-eBoard_mxCenter.php, /home/www/web7/html/header.php),
file: /home/www/web7/html/index.php # line:  70, cmd: include_once(/home/www/web7/html/blocks/block-eBoard_mxCenter.php, /home/www/web7/html/header.php, /home/www/web7/html/modules/blank_Home/index.php),
 


Die seite an sich leuft siehe  http://www.fun.mw.de

Kann mir bitte einer sagen warum diese fehlermeldung kommt ??
hab null plan mit SQL

MFG
Big fu

Titel: Re: Hilfe
Beitrag von: jogi24 am 23 September 2003, 14:15:20
hi

gehe mal bitte in deine datenbank

dort findest du mit sicherheit nuke_eboard...........

das must du ändern in
nuke_eBoard................

oder auch mx_eboard

in mx_eBoard

 ;)  ;)  ;)

[Editiert am 23/9/2003 von jogi24]
Titel: Re: Hilfe
Beitrag von: bigfu am 23 September 2003, 14:28:22
supi klappt

ich dachte schon ich hätte ein richtiges problem

DANKE!!
Titel: Re: Hilfe
Beitrag von: jogi24 am 23 September 2003, 14:33:48
hi

das ist immer zu beachten.
local ist das gross und klein schreiben nicht ganz so wichtig.
in netzt hingegen kann es böse folgen haben, sie dein fall  :D  :D  :D
Titel: Re: Hilfe
Beitrag von: jubilee am 23 September 2003, 19:33:02
 
Zitatdas ist immer zu beachten.
local ist das gross und klein schreiben nicht ganz so wichtig
Nope, auf Windows-Maschinen (95/98/etc) ist die Groß/Kleinschreibung nicht wichtig. Auf Unix-Maschinen dagegen schon und diese werden hauptsächlich als Server eingesetzt.
MfG
jubilee