[Solved] SQL trouble
Asked Modified Viewed 3,403 times
Wanabo
Wanabo 10
- Senior Member, joined since
- Contributed 598 posts on the community forums.
- Started 94 threads in the forums
- Started this discussions
Searching did not solve my problems, so perhaps one of you can!
My webhoster migrated from ensim to plesk and now parts of my websites are not displayed!:@
After studying panels etcetera I found that additional \ (BACKSLASH) was inserted in the code.
Example:
This happens also in the site description and other places.
According to my hoster this fault could be related to the difference in PHP versions. The ensim environment used PHP version 4 end the plesk environment uses PHP version 5.
Experimented with restoring backups. PHPMYadmin restore possible but fault still there. Restore function in PHPFusion not working anymore!:(
Questions:
1. Anybody knows / recognizes the backslash problem and has a solution!
2. Why can't I use internal restore function from Fusion?
I know I could restore some of the code by checking all the panels, but as this is just the first website and more will follow.
My webhoster migrated from ensim to plesk and now parts of my websites are not displayed!:@
After studying panels etcetera I found that additional \ (BACKSLASH) was inserted in the code.
Example:
Quote
google_color_link = \"0075EF\";
google_color_text = \"000000\";
google_color_url = \"008000\";
This happens also in the site description and other places.
According to my hoster this fault could be related to the difference in PHP versions. The ensim environment used PHP version 4 end the plesk environment uses PHP version 5.
Experimented with restoring backups. PHPMYadmin restore possible but fault still there. Restore function in PHPFusion not working anymore!:(
Questions:
1. Anybody knows / recognizes the backslash problem and has a solution!
2. Why can't I use internal restore function from Fusion?
I know I could restore some of the code by checking all the panels, but as this is just the first website and more will follow.
Edited by Wanabo on 07-05-2007 19:27,
Wanabo
Wanabo 10
- Senior Member, joined since
- Contributed 598 posts on the community forums.
- Started 94 threads in the forums
- Started this discussions
UPDATE
Strangely the directory * administration/db_backups/ was not cmodded to 777. [FIXED]
But now when I restore a backup in PHPFusion the complete database is erased!!!:o Even when restoring a fresh backup!
This does not work! For example the welcome text wil not show no matter what I put in there. And when I enter a ' or " this is replace by \' or \" . :@
Quote
2. Why can't I use internal restore function from Fusion?[/b][/color]
Strangely the directory * administration/db_backups/ was not cmodded to 777. [FIXED]
But now when I restore a backup in PHPFusion the complete database is erased!!!:o Even when restoring a fresh backup!
Quote
I know I could restore some of the code by checking all the panels, but as this is just the first website and more will follow.
This does not work! For example the welcome text wil not show no matter what I put in there. And when I enter a ' or " this is replace by \' or \" . :@
Falk
Falk 148
Need help?, Having trouble?
• View our Documentation for Guides, Standards and Functions
• Name and Organize your Topics and Content correctly in the corresponding Forums for best support results
• Attaching Log Files and Screenshots when reporting issues will help
• Provide with an URL to live example if one exists
• Please read the How to Report an Error post
• Please read and comply with the Code of Conduct
• View our Documentation for Guides, Standards and Functions
• Name and Organize your Topics and Content correctly in the corresponding Forums for best support results
• Attaching Log Files and Screenshots when reporting issues will help
• Provide with an URL to live example if one exists
• Please read the How to Report an Error post
• Please read and comply with the Code of Conduct
(¯·._.·(¯°·._.·°º*[ Project Manager ]*º°·._.·°¯)·._.·¯)
- Super Admin, joined since
- Contributed 6,201 posts on the community forums.
- Started 639 threads in the forums
- Answered 12 questions
Sounds like a gpc_quotex issue to me, check phpinfo and see what magic_qoutes_gpc and magic_qoutes_runtime are set to.
Wanabo
Wanabo 10
- Senior Member, joined since
- Contributed 598 posts on the community forums.
- Started 94 threads in the forums
- Started this discussions
Quote
Digitanium wrote:
Sounds like a gpc_quotex issue to me, check phpinfo and see what magic_qoutes_gpc and magic_qoutes_runtime are set to.
Found these settings in PHPinfo.
Configure Command '--enable-magic-quotes'
and
magic_quotes_gpc Off Off
magic_quotes_runtime On On
magic_quotes_sybase Off Off
Is this good or bad!!
The website in question is http://www.kiesverstandig.eu
Wanabo
Wanabo 10
- Senior Member, joined since
- Contributed 598 posts on the community forums.
- Started 94 threads in the forums
- Started this discussions
Update!
Digitaniums remark about quotes was correct. Mailed my hoster to change the setting from magic_quotes_runtime On to Off. Now it seems OK! :)
A Big Thank You to you Digitanium!;)
Digitaniums remark about quotes was correct. Mailed my hoster to change the setting from magic_quotes_runtime On to Off. Now it seems OK! :)
A Big Thank You to you Digitanium!;)
Falk
Falk 148
Need help?, Having trouble?
• View our Documentation for Guides, Standards and Functions
• Name and Organize your Topics and Content correctly in the corresponding Forums for best support results
• Attaching Log Files and Screenshots when reporting issues will help
• Provide with an URL to live example if one exists
• Please read the How to Report an Error post
• Please read and comply with the Code of Conduct
• View our Documentation for Guides, Standards and Functions
• Name and Organize your Topics and Content correctly in the corresponding Forums for best support results
• Attaching Log Files and Screenshots when reporting issues will help
• Provide with an URL to live example if one exists
• Please read the How to Report an Error post
• Please read and comply with the Code of Conduct
(¯·._.·(¯°·._.·°º*[ Project Manager ]*º°·._.·°¯)·._.·¯)
- Super Admin, joined since
- Contributed 6,201 posts on the community forums.
- Started 639 threads in the forums
- Answered 12 questions
Its magic_quotes_runtime, should be off imo, ask your host to consider turning off runtime but turn on quotes_gpc
magic_quotes_gpc Off Off
magic_quotes_runtime On On
To
magic_quotes_gpc On On
magic_quotes_runtime Off Off
magic_quotes_gpc Off Off
magic_quotes_runtime On On
To
magic_quotes_gpc On On
magic_quotes_runtime Off Off
Wanabo
Wanabo 10
- Senior Member, joined since
- Contributed 598 posts on the community forums.
- Started 94 threads in the forums
- Started this discussions
Yes after magic_quotes_runtime was set to off al was ok!
I have 2 domains, both were hosted on a ensim environment. I have to migrate because the ensim dashboard is malfunctioning.
A.t.m only kiesverstandig.eu is migrated so I could check the settings on my other properly working domain gebruikers.eu. However on this domain magic_quotes_gpc is set to off. Of course I could ask the hoster to turn on magic_quotes_gpc, but after googling about this subject many preferred magic_quotes_gpc to be turned Off.
So for the sake of experiment I am willing to ask my hoster to turn magic_quotes_gpc On, but what is there to gain with this setting??
I have 2 domains, both were hosted on a ensim environment. I have to migrate because the ensim dashboard is malfunctioning.
A.t.m only kiesverstandig.eu is migrated so I could check the settings on my other properly working domain gebruikers.eu. However on this domain magic_quotes_gpc is set to off. Of course I could ask the hoster to turn on magic_quotes_gpc, but after googling about this subject many preferred magic_quotes_gpc to be turned Off.
So for the sake of experiment I am willing to ask my hoster to turn magic_quotes_gpc On, but what is there to gain with this setting??
Category Forum
Official Core Support - 6Labels
None yet
Statistics
- Views 0 views
- Posts 6 posts
- Votes 0 votes
- Topic users 2 members
0 participants
Notifications
Track thread
You are not receiving notifications from this thread.
Related Questions