[SaN-DeeP]

Originally Posted by PcFreak

You cant upgrade the new version with the old version. To many changed was made.

But installing the new version is very easy. Del all old templates. Del the tables for the old staistic in your database. And then install the new one.

PcFreak

hey pcfreak.
thnx for the nice hack..
but as you specified when i deleted those 6 table entire forums crashed down

I fixed it, installing the new version. but it again had table prefix problems.

i had to manually run the queries using phpmyadmin finished everything till here ->

  $resetzeit = TIMENOW;
 
  UPDATE vb3_statistik_zaehler
  SET Summe = '$resetzeit'
  WHERE Zaehler_fuer  = 'Statistik_Aktiv'
 ;

 print_form_header('install_statistik_english', '');
 print_table_header("vBulletin 3 Statistik 2.0 Installation Script");
 print_description_row("Congratulations! The board statistics version 2.0 was successfully installed!<br><b>PLEASE DELETE THIS FILE!</b>");
 
}

?>

not sure what to do.
i ran the foll. query sucessfully ->

UPDATE vb3_statistik_zaehler
  SET Summe = '$resetzeit'
  WHERE Zaehler_fuer  = 'Statistik_Aktiv'
 ;

again via phpmyadmin.

but now when i goto my stats page.
this is the error i am getting.

 Database error in vBulletin 3.0.0:
Invalid SQL: 
  SELECT Summe as Datum
  FROM statistik_zaehler
  WHERE Zaehler_fuer = 'Statistik_Aktiv'
		
mysql error: Table ***.statistik_zaehler' doesn't exist
mysql error number: 1146

i am using vb3_ as table prefix.

Thnx a lot for this nice STATS ALways useful
Regards,