• If you are still using CentOS 7.9, it's time to convert to Alma 8 with the free centos2alma tool by Plesk or Plesk Migrator. Please let us know your experiences or concerns in this thread:
    CentOS2Alma discussion

error in plesk backup restore

C

cybernova

Guest
Hi guys,

I get the following error while trying to restore from the backup repository.

+++++++++++
Can't execute update IP_Addresses set ssl_certificate_id='1 where id='70': MySql error 1064:You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '70'' at line 1Execute file name: D:\Program Files\SWsoft\Plesk\admin\bin\ifmng.exe
+++++++++++++

any ideas on the resolution ?
 
further more i got the following error while running the plesk restore manually

++++++++
See the end of this message for details on invoking
just-in-time (JIT) debugging instead of this dialog box.

************** Exception Text **************
System.Exception: Error in execute ''D:\Program Files\SWsoft\Plesk\admin\bin\ifmng.exe' --reread':

Can't execute update IP_Addresses set ssl_certificate_id='1 where id='70': MySql error 1064:You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '70'' at line 1
at psacommon.ExecUtils.execUtil(String utilName, String Arguments, String inputString, Hashtable envs)
at psacommon.ExecUtils.execUtil(String utilName, String Arguments)
at restore.PSARestore.PSARestore_Load(Object sender, EventArgs e)
at System.Windows.Forms.Form.OnLoad(EventArgs e)
at System.Windows.Forms.Form.OnCreateControl()
at System.Windows.Forms.Control.CreateControl(Boolean fIgnoreVisible)
at System.Windows.Forms.Control.CreateControl()
at System.Windows.Forms.Control.WmShowWindow(Message& m)
at System.Windows.Forms.Control.WndProc(Message& m)
at System.Windows.Forms.ScrollableControl.WndProc(Message& m)
at System.Windows.Forms.ContainerControl.WndProc(Message& m)
at System.Windows.Forms.Form.WmShowWindow(Message& m)
at System.Windows.Forms.Form.WndProc(Message& m)
at System.Windows.Forms.ControlNativeWindow.OnMessage(Message& m)
at System.Windows.Forms.ControlNativeWindow.WndProc(Message& m)
at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)


************** Loaded Assemblies **************
mscorlib
Assembly Version: 1.0.5000.0
Win32 Version: 1.1.4322.2300
CodeBase: file:///c:/windows/microsoft.net/framework/v1.1.4322/mscorlib.dll
----------------------------------------
restore
Assembly Version: 1.0.2142.12561
Win32 Version: 1.0.2142.12561
CodeBase: file:///D:/Program%20Files/SWsoft/Plesk/admin/bin/restore.exe
----------------------------------------
System.Windows.Forms
Assembly Version: 1.0.5000.0
Win32 Version: 1.1.4322.2300
CodeBase: file:///c:/windows/assembly/gac/system.windows.forms/1.0.5000.0__b77a5c561934e089/system.windows.forms.dll
----------------------------------------
System
Assembly Version: 1.0.5000.0
Win32 Version: 1.1.4322.2300
CodeBase: file:///c:/windows/assembly/gac/system/1.0.5000.0__b77a5c561934e089/system.dll
----------------------------------------
psaobsolete
Assembly Version: 1.0.2231.33463
Win32 Version: 7, 5, 6003, 0
CodeBase: file:///D:/Program%20Files/SWsoft/Plesk/admin/bin/psaobsolete.DLL
----------------------------------------
psacommon
Assembly Version: 1.0.2142.13816
Win32 Version: 1.0.2142.13816
CodeBase: file:///D:/Program%20Files/SWsoft/Plesk/admin/bin/psacommon.DLL
----------------------------------------
FtpWebRequest
Assembly Version: 1.0.2142.13817
Win32 Version: 1.0.2142.13817
CodeBase: file:///D:/Program%20Files/SWsoft/Plesk/admin/bin/FtpWebRequest.DLL
----------------------------------------
psabackup
Assembly Version: 1.0.2217.24381
Win32 Version: 1.0.2217.24381
CodeBase: file:///D:/Program%20Files/SWsoft/Plesk/admin/bin/psabackup.DLL
----------------------------------------
System.Xml
Assembly Version: 1.0.5000.0
Win32 Version: 1.1.4322.2300
CodeBase: file:///c:/windows/assembly/gac/system.xml/1.0.5000.0__b77a5c561934e089/system.xml.dll
----------------------------------------
Interop.WindowsInstaller
Assembly Version: 1.0.0.0
Win32 Version: 1.0.0.0
CodeBase: file:///D:/Program%20Files/SWsoft/Plesk/admin/bin/Interop.WindowsInstaller.DLL
----------------------------------------
CustomMarshalers
Assembly Version: 1.0.5000.0
Win32 Version: 1.1.4322.573
CodeBase: file:///c:/windows/assembly/gac/custommarshalers/1.0.5000.0__b03f5f7f11d50a3a/custommarshalers.dll
----------------------------------------
System.ServiceProcess
Assembly Version: 1.0.5000.0
Win32 Version: 1.1.4322.2300
CodeBase: file:///c:/windows/assembly/gac/system.serviceprocess/1.0.5000.0__b03f5f7f11d50a3a/system.serviceprocess.dll
----------------------------------------
System.Drawing
Assembly Version: 1.0.5000.0
Win32 Version: 1.1.4322.2300
CodeBase: file:///c:/windows/assembly/gac/system.drawing/1.0.5000.0__b03f5f7f11d50a3a/system.drawing.dll
----------------------------------------

************** JIT Debugging **************
To enable just in time (JIT) debugging, the config file for this
application or machine (machine.config) must have the
jitDebugging value set in the system.windows.forms section.
The application must also be compiled with debugging
enabled.

For example:

<configuration>
<system.windows.forms jitDebugging="true" />
</configuration>

When JIT debugging is enabled, any unhandled exception
will be sent to the JIT debugger registered on the machine
rather than being handled by this dialog.
++++++++++++++

please help
 
Back
Top