pragmaMx Support Forum

pragmaMx => Installation & Update => Thema gestartet von: cawres am 08 Oktober 2003, 23:44:15

Titel: bitte hilfeeeeeeeeeeeeeeeee
Beitrag von: cawres am 08 Oktober 2003, 23:44:15
Error sql_query():
qry: insert into nuke_stats_date values('2003', '12', '18', '0')
descr: Table 'db79828415.nuke_stats_date' doesn't exist ( mysql 1146 )

Error sql_query():
qry: insert into nuke_stats_date values('2003', '12', '19', '0')
descr: Table 'db79828415.nuke_stats_date' doesn't exist ( mysql 1146 )

Error sql_query():
qry: insert into nuke_stats_date values('2003', '12', '20', '0')
descr: Table 'db79828415.nuke_stats_date' doesn't exist ( mysql 1146 )

Error sql_query():
qry: insert into nuke_stats_date values('2003', '12', '21', '0')
descr: Table 'db79828415.nuke_stats_date' doesn't exist ( mysql 1146 )

Error sql_query():
qry: insert into nuke_stats_date values('2003', '12', '22', '0')
descr: Table 'db79828415.nuke_stats_date' doesn't exist ( mysql 1146 )

Error sql_query():
qry: insert into nuke_stats_date values('2003', '12', '23', '0')
descr: Table 'db79828415.nuke_stats_date' doesn't exist ( mysql 1146 )

Error sql_query():
qry: insert into nuke_stats_date values('2003', '12', '24', '0')
descr: Table 'db79828415.nuke_stats_date' doesn't exist ( mysql 1146 )

Error sql_query():
qry: insert into nuke_stats_date values('2003', '12', '25', '0')
descr: Table 'db79828415.nuke_stats_date' doesn't exist ( mysql 1146 )

Error sql_query():
qry: insert into nuke_stats_date values('2003', '12', '26', '0')
descr: Table 'db79828415.nuke_stats_date' doesn't exist ( mysql 1146 )

Error sql_query():
qry: insert into nuke_stats_date values('2003', '12', '27', '0')
descr: Table 'db79828415.nuke_stats_date' doesn't exist ( mysql 1146 )

Error sql_query():
qry: insert into nuke_stats_date values('2003', '12', '28', '0')
descr: Table 'db79828415.nuke_stats_date' doesn't exist ( mysql 1146 )

Error sql_query():
qry: insert into nuke_stats_date values('2003', '12', '29', '0')
descr: Table 'db79828415.nuke_stats_date' doesn't exist ( mysql 1146 )

Error sql_query():
qry: insert into nuke_stats_date values('2003', '12', '30', '0')
descr: Table 'db79828415.nuke_stats_date' doesn't exist ( mysql 1146 )

Error sql_query():
qry: insert into nuke_stats_date values('2003', '12', '31', '0')
descr: Table 'db79828415.nuke_stats_date' doesn't exist ( mysql 1146 )

Error sql_query():
qry: select hour from nuke_stats_hour where (year='2003') and (month='10') and (date='08')
descr: Table 'db79828415.nuke_stats_hour' doesn't exist ( mysql 1146 )

Error sql_num_rows():
descr: mysql_num_rows(): supplied argument is not a valid MySQL result resource

Error sql_query():
qry: insert into nuke_stats_hour values('2003', '10', '08', '0', '0')
descr: Table 'db79828415.nuke_stats_hour' doesn't exist ( mysql 1146 )

Error sql_query():
qry: insert into nuke_stats_hour values('2003', '10', '08', '1', '0')
descr: Table 'db79828415.nuke_stats_hour' doesn't exist ( mysql 1146 )

Error sql_query():
qry: insert into nuke_stats_hour values('2003', '10', '08', '2', '0')
descr: Table 'db79828415.nuke_stats_hour' doesn't exist ( mysql 1146 )

Error sql_query():
qry: insert into nuke_stats_hour values('2003', '10', '08', '3', '0')
descr: Table 'db79828415.nuke_stats_hour' doesn't exist ( mysql 1146 )

Error sql_query():
qry: insert into nuke_stats_hour values('2003', '10', '08', '4', '0')
descr: Table 'db79828415.nuke_stats_hour' doesn't exist ( mysql 1146 )

Error sql_query():
qry: insert into nuke_stats_hour values('2003', '10', '08', '5', '0')
descr: Table 'db79828415.nuke_stats_hour' doesn't exist ( mysql 1146 )

Error sql_query():
qry: insert into nuke_stats_hour values('2003', '10', '08', '6', '0')
descr: Table 'db79828415.nuke_stats_hour' doesn't exist ( mysql 1146 )

Error sql_query():
qry: insert into nuke_stats_hour values('2003', '10', '08', '7', '0')
descr: Table 'db79828415.nuke_stats_hour' doesn't exist ( mysql 1146 )

Error sql_query():
qry: insert into nuke_stats_hour values('2003', '10', '08', '8', '0')
descr: Table 'db79828415.nuke_stats_hour' doesn't exist ( mysql 1146 )

Error sql_query():
qry: insert into nuke_stats_hour values('2003', '10', '08', '9', '0')
descr: Table 'db79828415.nuke_stats_hour' doesn't exist ( mysql 1146 )

Error sql_query():
qry: insert into nuke_stats_hour values('2003', '10', '08', '10', '0')
descr: Table 'db79828415.nuke_stats_hour' doesn't exist ( mysql 1146 )

Error sql_query():
qry: insert into nuke_stats_hour values('2003', '10', '08', '11', '0')
descr: Table 'db79828415.nuke_stats_hour' doesn't exist ( mysql 1146 )

Error sql_query():
qry: insert into nuke_stats_hour values('2003', '10', '08', '12', '0')
descr: Table 'db79828415.nuke_stats_hour' doesn't exist ( mysql 1146 )

Error sql_query():
qry: insert into nuke_stats_hour values('2003', '10', '08', '13', '0')
descr: Table 'db79828415.nuke_stats_hour' doesn't exist ( mysql 1146 )

Error sql_query():
qry: insert into nuke_stats_hour values('2003', '10', '08', '14', '0')
descr: Table 'db79828415.nuke_stats_hour' doesn't exist ( mysql 1146 )

Error sql_query():
qry: insert into nuke_stats_hour values('2003', '10', '08', '15', '0')
descr: Table 'db79828415.nuke_stats_hour' doesn't exist ( mysql 1146 )

Error sql_query():
qry: insert into nuke_stats_hour values('2003', '10', '08', '16', '0')
descr: Table 'db79828415.nuke_stats_hour' doesn't exist ( mysql 1146 )

Error sql_query():
qry: insert into nuke_stats_hour values('2003', '10', '08', '17', '0')
descr: Table 'db79828415.nuke_stats_hour' doesn't exist ( mysql 1146 )

Error sql_query():
qry: insert into nuke_stats_hour values('2003', '10', '08', '18', '0')
descr: Table 'db79828415.nuke_stats_hour' doesn't exist ( mysql 1146 )

Error sql_query():
qry: insert into nuke_stats_hour values('2003', '10', '08', '19', '0')
descr: Table 'db79828415.nuke_stats_hour' doesn't exist ( mysql 1146 )

Error sql_query():
qry: insert into nuke_stats_hour values('2003', '10', '08', '20', '0')
descr: Table 'db79828415.nuke_stats_hour' doesn't exist ( mysql 1146 )

Error sql_query():
qry: insert into nuke_stats_hour values('2003', '10', '08', '21', '0')
descr: Table 'db79828415.nuke_stats_hour' doesn't exist ( mysql 1146 )

Error sql_query():
qry: insert into nuke_stats_hour values('2003', '10', '08', '22', '0')
descr: Table 'db79828415.nuke_stats_hour' doesn't exist ( mysql 1146 )

Error sql_query():
qry: insert into nuke_stats_hour values('2003', '10', '08', '23', '0')
descr: Table 'db79828415.nuke_stats_hour' doesn't exist ( mysql 1146 )

Error sql_query():
qry: update nuke_stats_year set hits=hits+1 where year='2003'
descr: Table 'db79828415.nuke_stats_year' doesn't exist ( mysql 1146 )

Error sql_query():
qry: update nuke_stats_month set hits=hits+1 where (year='2003') and (month='10')
descr: Table 'db79828415.nuke_stats_month' doesn't exist ( mysql 1146 )

Error sql_query():
qry: update nuke_stats_date set hits=hits+1 where (year='2003') and (month='10') and (date='08')
descr: Table 'db79828415.nuke_stats_date' doesn't exist ( mysql 1146 )

Error sql_query():
qry: update nuke_stats_hour set hits=hits+1 where (year='2003') and (month='10') and (date='08') and (hour='23')
descr: Table 'db79828415.nuke_stats_hour' doesn't exist ( mysql 1146 )





was sol das denn  kann mir jemand helfen
Titel: Re: bitte hilfeeeeeeeeeeeeeeeee
Beitrag von: Martin am 09 Oktober 2003, 00:12:52
wie in der Fehlermeldung schon richtig steht, deine Tabellen existieren nicht.

Wenn du eine genauere Fehleranalyse möchtest, musst du auch mehr Angaben machen.
(was wolltest du machen, hast du schon gemacht etc...)
Titel: Re: bitte hilfeeeeeeeeeeeeeeeee
Beitrag von: _Gerry_ am 09 Oktober 2003, 09:14:10
Wie Martin schon gesagt hat, mehr Angaben wären nicht schlecht!
Schau mal in deine Datenbank ob die Tabelle nuke_stats vorhanden ist.
Wenn nicht dann leg sie mal an.

Struktur der nuke_stats:
 
CREATE TABLE nuke_stats (
  year smallint(6) NOT NULL default '0',
  month tinyint(4) NOT NULL default '0',
  date tinyint(4) NOT NULL default '0',
  hour tinyint(4) NOT NULL default '0',
  hits int(11) NOT NULL default '0',
  PRIMARY KEY  (year,month,date,hour)
) TYPE=MyISAM;

Titel: Re: bitte hilfeeeeeeeeeeeeeeeee
Beitrag von: cawres am 09 Oktober 2003, 15:52:46
danke euch habe schonnn  :-))