pragmaMx Support Forum

Hallo !
Wenn das Datenbankbackup (aus dem Admin-Menü) bei der Einstellung: als unkomprimierte SQL Datei
leere Dateien bzw. nur mit einigen Zeilen drinnen produziert, dann muss folgende Datei einmal so abgeändert werden
admin/modules/backup.php ca Zeile 61
alt:

system(sprintf('mysqldump --opt -h %s -u %s -p%s %s > %s/'.$thefile.'', $dbhost, $dbuname, $dbpass, $dbname, $path ));


neu

system(sprintf('mysqldump -q --add-drop-table --extended-insert -h %s -u %s -p%s %s > %s/'.$thefile.'', $dbhost, $dbuname, $dbpass, $dbname, $path ));


MfG
jubilee

Danke für den Hinweis!
Ich bekomme allerdinges folgende Fehlermeldungen: (Bakup wird aber gemacht)
Warning: mysql_query(): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) in /homepages/36/d***/htdocs/version2/html/blocks/block-WebChatMini.php on line 46

Warning: mysql_query(): A link to the server could not be established in /homepages/36/d***/htdocs/version2/html/blocks/block-WebChatMini.php on line 46

Warning: mysql_query(): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) in /homepages/36/d***/htdocs/version2/html/blocks/block-WebChatMini.php on line 49

Warning: mysql_query(): A link to the server could not be established in /homepages/36/d***/htdocs/version2/html/blocks/block-WebChatMini.php on line 49

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /homepages/36/d***/htdocs/version2/html/blocks/block-WebChatMini.php on line 50

Hallo !
diesen Abschnitt in der admin/modules/backup.php:

MYSQL_CLOSE();
include("header.php");
GraphicAdmin();
OpenTable();
echo "<center><font class=\"title\"><b>"._SAVEDATABASE."</b></font></center>";
CloseTable();
echo "<br>";
OpenTable();
echo $msg;
echo "<br><center><a href=\"admin.php?op=backup\">Weiter</a></center>";
CloseTable();
include("footer.php");
}


so abändern:

         
                   #MYSQL_CLOSE();
include("header.php");
GraphicAdmin();
OpenTable();
echo "<center><font class=\"title\"><b>"._SAVEDATABASE."</b></font></center>";
CloseTable();
echo "<br>";
OpenTable();
echo $msg;
echo "<br><center><a href=\"admin.php?op=backup\">Weiter</a></center>";
CloseTable();
include("footer.php");
                }


dann sind auch die Fehlermeldungen weg .
MfG
jubilee

 :genie:Vielen Dank! Damit funktioniert das DB Back erstmalig bei mir! Konnte schon oft nicht schlafen, weil wir nie ein Backup hinbekommen haben...Supi! :D

Mein Backup ist problemlos, aber ich habe ein anderes Problem:

ZitatWarning: mysql_query() [function.mysql-query]: Access denied for user 'nobody'@'localhost' (using password: NO) in /is/htdocs/wp1006299_E7CGN1HDHL/www/blocks/block-Total_Hits.php on line 32

Warning: mysql_query() [function.mysql-query]: A link to the server could not be established in /is/htdocs/wp1006299_E7CGN1HDHL/www/blocks/block-Total_Hits.php on line 32

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /is/htdocs/wp1006299_E7CGN1HDHL/www/blocks/block-Total_Hits.php on line 34

Warning: mysql_query() [function.mysql-query]: Access denied for user 'nobody'@'localhost' (using password: NO) in /is/htdocs/wp1006299_E7CGN1HDHL/www/blocks/block-Total_Hits.php on line 37

Warning: mysql_query() [function.mysql-query]: A link to the server could not be established in /is/htdocs/wp1006299_E7CGN1HDHL/www/blocks/block-Total_Hits.php on line 37

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /is/htdocs/wp1006299_E7CGN1HDHL/www/blocks/block-Total_Hits.php on line 38

Warning: mysql_query() [function.mysql-query]: Access denied for user 'nobody'@'localhost' (using password: NO) in /is/htdocs/wp1006299_E7CGN1HDHL/www/blocks/block-Total_Hits.php on line 44

Warning: mysql_query() [function.mysql-query]: A link to the server could not be established in /is/htdocs/wp1006299_E7CGN1HDHL/www/blocks/block-Total_Hits.php on line 44

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /is/htdocs/wp1006299_E7CGN1HDHL/www/blocks/block-Total_Hits.php on line 46

Warning: mysql_query() [function.mysql-query]: Access denied for user 'nobody'@'localhost' (using password: NO) in /is/htdocs/wp1006299_E7CGN1HDHL/www/blocks/block-Total_Hits.php on line 49

Warning: mysql_query() [function.mysql-query]: A link to the server could not be established in /is/htdocs/wp1006299_E7CGN1HDHL/www/blocks/block-Total_Hits.php on line 49

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /is/htdocs/wp1006299_E7CGN1HDHL/www/blocks/block-Total_Hits.php on line 50

Warning: mysql_query() [function.mysql-query]: Access denied for user 'nobody'@'localhost' (using password: NO) in /is/htdocs/wp1006299_E7CGN1HDHL/www/blocks/block-Total_Hits.php on line 55

Warning: mysql_query() [function.mysql-query]: A link to the server could not be established in /is/htdocs/wp1006299_E7CGN1HDHL/www/blocks/block-Total_Hits.php on line 55

Warning: mysql_result(): supplied argument is not a valid MySQL result resource in /is/htdocs/wp1006299_E7CGN1HDHL/www/blocks/block-Total_Hits.php on line 57

Warning: mysql_query() [function.mysql-query]: Access denied for user 'nobody'@'localhost' (using password: NO) in /is/htdocs/wp1006299_E7CGN1HDHL/www/blocks/block-Total_Hits.php on line 58

Warning: mysql_query() [function.mysql-query]: A link to the server could not be established in /is/htdocs/wp1006299_E7CGN1HDHL/www/blocks/block-Total_Hits.php on line 58

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /is/htdocs/wp1006299_E7CGN1HDHL/www/blocks/block-Total_Hits.php on line 59

Warning: mysql_query() [function.mysql-query]: Access denied for user 'nobody'@'localhost' (using password: NO) in /is/htdocs/wp1006299_E7CGN1HDHL/www/blocks/block-Total_Hits.php on line 62

Warning: mysql_query() [function.mysql-query]: A link to the server could not be established in /is/htdocs/wp1006299_E7CGN1HDHL/www/blocks/block-Total_Hits.php on line 62

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /is/htdocs/wp1006299_E7CGN1HDHL/www/blocks/block-Total_Hits.php on line 63

das ist eine Fehlermeldung... :-\

Backup geht aber....

Edit:  Wenn ich den Block deaktiviert habe, dann kommt keine.... aber warum?

Hallo !
Änder den Block bitte ab.
Ersetze mysql_query durch sql_query
Ersetze mysql_fetch_row durch sql_fetch_row
Ersetze mysql_num_rows durch sql_num_rows

Bzw so sollte es aussehen:


if (!defined("mxMainFileLoaded")) die ("You can't access this file directly...");

$mxblockcache = TRUE;

global $prefix, $startdate;

$result = sql_query("SELECT count FROM ".$prefix."_counter WHERE type='total' AND var='hits'");
$result = sql_fetch_row($result);
$content = "<center><small>"._WERECEIVED."</small><br><b><a href=\"modules.php?name=maaXStat2\">$result[0]</a></b><br><small>"._PAGESVIEWS." $startdate</small><br><br>";

$a = 1; $d=0; $j=0;
$result=sql_query("select lid, hits from ".$prefix."_links_links order by lid");
    $dresult=0;
    while(list($lid, $hits) = sql_fetch_row($result)) {
$dresult = $dresult + $hits;
    }
    $result=sql_query("select * from ".$prefix."_links_links");
    $numrows =sql_num_rows($result);
    $content .= "<font class=\"boxcontent\"><b>$numrows </b>" ._LINKS."<br><b>$dresult</b> "._TIMESL." <br><br></font>";
  $a++;


$a = 1;
$result=sql_query("select lid, hits from ".$prefix."_downloads_downloads order by lid");
    $dresult=0;
    while(list($lid, $hits) = sql_fetch_row($result)) {
$dresult = $dresult + $hits;
    }
    $result=sql_query("select * from ".$prefix."_downloads_downloads");
    $numrows =sql_num_rows($result);
    $content .= "<font class=\"boxcontent\"><b>$numrows </b>" ._DOWNS."<br><b>$dresult</b> "._TIMES." <br></font><br>";
  $a++;

 
$xunum =  sql_query("select count(*) as count from ".$prefix."_downloads_downloads");

$xunum =   mysql_result($xunum,0,"count");
$dresult = sql_query("select hits from ".$prefix."_downloads_downloads" );
    while(list($hits) = sql_fetch_row($dresult)){
$d+= $hits;
}
         $jresult = sql_query("select filesize from ".$prefix."_downloads_downloads" );
    while(list($filesize) = sql_fetch_row($jresult)){
  $j+= $filesize;
}
         $mb = 1024*1024;
    $m = sprintf ("%01.2f",$j/$mb) . " ";

$content .= "<b><font class=\"pn-normal\">Files MB :</font> $m</b></center>\n";

 :thumbup: :thumbup:  geil es läuft!

Ich habe da mal eine persönliche Frage:

Was machst du beruflich? 
Mit welchem tool arbeitest du? oder liest du die Fehler selber aus den Quellcode?

Hallo !

ZitatWas machst du beruflich? 

Ich arbeite als Kommunikationselektroniker.

ZitatMit welchem tool arbeitest du?

Ausser dem standard Microsoft Editor (edit bzw. notepad) verwende ich für HTML-Erstellung
den Namo Webeditor 6, für PHP-Arbeiten verwende ich Maguma Studio Free 1.3.3

Zitatoder liest du die Fehler selber aus den Quellcode?

In diesem Fall ja. Da war der Fehler offensichtlich, da normalerweise im MX ein selbsterstellter Extender die Verbindung zur Datenbank herstellt. dort lauten die Befehle anders als beim im PHP integrierten Datenbankextender. Daher konnte man das sofort sehen .

MfG
jubilee