FUDforum
Fast Uncompromising Discussions. FUDforum will get your users talking.

Home » FUDforum Development » Bug Reports » Unable to import into FUDForum2Go appliance
Show: Today's Messages :: Polls :: Message Navigator
Return to the default flat view Create a new topic Submit Reply
Re: Unable to import into FUDForum2Go appliance [message #162127 is a reply to message #162126] Tue, 23 March 2010 21:16 Go to previous messageGo to previous message
naudefj is currently offline  naudefj   South Africa
Messages: 3771
Registered: December 2004
Karma:
Senior Member
Administrator
Core Developer
Here is a patch you can try. If it works, I will commit it to the repository:

Index: install/www_root/adm/admimport.php
===================================================================
--- install/www_root/adm/admimport.php	(revision 4928)
+++ install/www_root/adm/admimport.php	(working copy)
@@ -196,6 +189,14 @@
 				// Reverse formatting applied in admdump.php.
 				$line = str_replace('\n', "\n", $line);
 
+				// Handle different quote styles between databases for cross-database export/imports.
+				// For example, change \' --> '' (MySQL's --> SQLite or pgSQL)
+				if (__dbtype__ == 'mysql') {
+					$line = str_replace("''", "\'", $line);
+				} else {
+					$line = str_replace("\\'", "''", $line);
+				}
+
 				if (($line = trim($line))) {
 					if ($line{0} != '(') {
 						if ($tmp && !$skip) {
[Message index]
 
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Previous Topic: XML Aggregation fails if articles have no 'link' element
Next Topic: Messages are garbled after mporting from backup
Goto Forum:
  

-=] Back to Top [=-
[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Nov 28 06:23:49 GMT 2024

Total time taken to generate the page: 0.04207 seconds