As mentioned in previous posts, I have moved my website to a different web host. I got the site up and running (more or less) but I'm having some issues with regards to layout.
The only Block Position that is available is Left Blocks and when I try to create a new position it gives me the following error:
Exit-Handler: Exiting after SQL-error
--------------------------------------------------------------------------------
Error! Creation attempt failed.
Also, most of the Modules are in the 3rd Party Panel and when I try to move them, I get the following error:
Exit-Handler: Exiting after SQL-error
--------------------------------------------------------------------------------
Error! Sorry! Could not add module to module category.
Also, for some reason, when I try to add "php_flag display_errors on" to the .htaccess file I get a database connection error on the page and get the following entry in my server's Error Log:
.htaccess: Invalid command 'php_flag', perhaps misspelled or defined by a module not included in the server configuration
Anyone have any ideas? I should mention that I Exported my MySQL database (version 4.1.20) using the SQL export compatibility set to MYSQL40 and Imported the database to my new host (version 5.0.85).
--
Christopher Pelletier
NorthumberlandView.ca
A View Like No Other
Watch
GitHub Core
Show your support for Zikula! Sign up at Github account and watch the Core project!
GitHub Modules
Forum Activity
- rgasch created topic »Using PageUtil::addVar() to load script code« 11:48 AM
- michiel responded to »password problem« 10:01 AM
- mazdev responded to »Hide "Register new account" and change template to 3 col« 07:50 AM
- mesteele101 created topic »Zikula 1.3.3 - Site Search 1.5.2 - Unable to turn off plug-ins« 07:48 AM
- mesteele101 responded to »ERR (3): E_USER_ERROR: Smarty error: [in pagesvar:pagesitem2en line XXX]…« 25. May
- mazdev responded to »Pages 2.5.0 and updating - Page not found« 25. May
- mesteele101 responded to »Zikula 1.3.3 - Selecting a category in Pages not working« 25. May
Zikula Blog
- Anatomy of Open Source Projects on Mar 07
- Continuous Review on Mar 01
- Not Invented Here on Feb 24
- How to Contribute Your Code at Github on Jan 13
- 10 Steps to Coding-Nirvana: Tips for Successful Module Writing on Nov 12
- Submitting Bug Report Tickets That Get Results on Aug 17
- Cozi Tricks #1: Syntax Highlighting on Aug 07
Login
Migrating/Moving to a new Server
-
-
- Rank: Developer
- Registered: Jun 16, 2003
- Last visit: May 29, 2010
- Posts: 1966
Posted: Jan 16, 2010 - 04:01 PM
just guessing:
1) you have new dbuser name because you are on new host and need to adjust config.php
2) new host has different restrictions regarding use of .htaccess and you need to use php.ini instead. -
- Rank: Softmore
- Registered: Jul 10, 2006
- Posts: 315
Posted: Jan 16, 2010 - 04:08 PM
I went through the install process for Zikula 1.1.2 and put in the new dbuser name and DB name. I checked the config.php and it's fine.
I've heard the php.ini mentioned a number of times but have no idea how to access it. I think it's done by the server admin, isn't it?
--
Christopher Pelletier
NorthumberlandView.ca
A View Like No Other -
- Rank: Developer
- Registered: Jun 16, 2003
- Last visit: May 29, 2010
- Posts: 1966
Posted: Jan 16, 2010 - 04:12 PM
re: php.ini
it depends on the host. mine runs PHP as cgi and therefore .htaccess is limited. I use php.ini and the host can provide a 'model' to use. I suggest you ask you host or check their support forums for the model.
if your DB credentials are inaccurate it seems nothing would work... maybe try disabling the .htaccess in your site root and see what happens. -
- Rank: Softmore
- Registered: Jul 10, 2006
- Posts: 315
Posted: Jan 16, 2010 - 04:16 PM
I removed the .htaccess file and tried to creat a block position with the same result
--
Christopher Pelletier
NorthumberlandView.ca
A View Like No Other -
- Rank: Developer
- Registered: Dec 31, 1969
- Last visit: Jun 01, 2010
- Posts: 6859
Posted: Jan 16, 2010 - 04:58 PM
Who are you hosting with? It sounds like it could be a server issue. What version of MySQL/PHP are they running?
--
Home Page | Find on Facebook | Follow on Twitter
-
- Rank: Softmore
- Registered: Jul 10, 2006
- Posts: 315
Posted: Jan 16, 2010 - 05:00 PM
HostPapa. They're using MySQL 5.0.85 and PHP 5.2.11.
--
Christopher Pelletier
NorthumberlandView.ca
A View Like No Other -
- Rank: Softmore
- Registered: Jul 10, 2006
- Posts: 315
Posted: Jan 16, 2010 - 06:31 PM
I went into config.php and changed Development Mode to 1 and got the following message:
Parse error: syntax error, unexpected $end in /home/(my username)/public_html/config/config.php on line 1
I changed it back to 0 and am still getting the same message.
--
Christopher Pelletier
NorthumberlandView.ca
A View Like No Other -
**unknown user**
- Rank: Helper
- Registered: Mar 16, 2002
- Last visit: May 18, 2010
- Posts: 985
Posted: Jan 16, 2010 - 09:49 PM
- development mode 1 is not for you
- line 1? check for unwanted characters ....
What editor did you use to alter config.php??
I'm guessing something got mixed up there...
- Igor -
- Rank: Softmore
- Registered: Jul 10, 2006
- Posts: 315
Posted: Jan 16, 2010 - 09:57 PM
After a couple of reinstalls it looks like things are mostly back to normal....
I am however getting the following error when I try to post an article using PagEd:
0.010s> insert into zk_paged_titles (topic_id, template_id, num_sections) values (2, 0, 2)
0.010s> SQL ERROR: Duplicate entry '0' for key 1
Any thoughts?
--
Christopher Pelletier
NorthumberlandView.ca
A View Like No Other -
- Rank: Softmore
- Registered: Jul 10, 2006
- Posts: 315
Posted: Jan 16, 2010 - 10:26 PM
HUZZAH! Success! I went into the database and changed the "x"_ID to autoincrement and it's working! Yay!
--
Christopher Pelletier
NorthumberlandView.ca
A View Like No Other
- Moderated by:
- Support
