Having issue with installation

Staxed

Staxed

Active member
I recently moved to a new server and apparently something somewhere is conflicting with Xenforo.

The one forum I transferred over isn't working, and I'm getting an error when I try to install a new one as well. I have a support ticket opened but figured I'd see if anyone else can help while I wait for a response.

I've checked on the forums, and tried everything in the threads I found (http://xenforo.com/community/threads/upgrading-server.30960/ and http://xenforo.com/community/threads/installation-error-for-latest-version-1-1-3.33560/#post-382655)

Steps I've taken:
  • Upgraded to most recent php version (5.3.17)
  • Made sure mysql and mysqli extentions are updated
  • updated Zend Guard
  • cleared the entire database after every try to insure that wasn't the issue with each change.
  • set php_admin_value[memory_limit] = 128M
  • set php_admin_value[post_max_size] = 8M
  • set php_admin_value[upload_max_filesize] = 8M
  • set mysql packet size to 64M
any ideas on what else I can try?
----------
Code: 
[SIZE=5][B][FONT=Trebuchet MS][SIZE=16px]Server Error[/SIZE][/FONT][/B][/SIZE]

[SIZE=13px][FONT=Trebuchet MS]unserialize() [<a href='function.unserialize'>function.unserialize</a>]: Error at offset 0 of 1 bytes[/FONT][/SIZE]
[LIST=1]
[*][B]XenForo_Application::handlePhpError()[/B]
[*][B]unserialize()[/B] in [B]XenForo/Model/StyleProperty.php[/B] at line [B]667[/B]
[*][B]XenForo_Model_StyleProperty->updatePropertyCacheInStyle()[/B] in [B]XenForo/Model/StyleProperty.php[/B] at line [B]632[/B]
[*][B]XenForo_Model_StyleProperty->rebuildPropertyCacheInStyleAndChildren()[/B] in [B]XenForo/Model/StyleProperty.php[/B] at line [B]2316[/B]
[*][B]XenForo_Model_StyleProperty->importStylePropertiesFromArray()[/B] in [B]XenForo/Model/StyleProperty.php[/B] at line [B]2187[/B]
[*][B]XenForo_Model_StyleProperty->importStylePropertyXml()[/B] in [B]XenForo/Model/StyleProperty.php[/B] at line [B]2120[/B]
[*][B]XenForo_Model_StyleProperty->importStylePropertyDevelopmentXml()[/B] in [B]XenForo/CacheRebuilder/ImportMasterData.php[/B] at line [B]45[/B]
[*][B]XenForo_CacheRebuilder_ImportMasterData->rebuild()[/B] in [B]XenForo/ControllerHelper/CacheRebuild.php[/B] at line [B]26[/B]
[*][B]XenForo_ControllerHelper_CacheRebuild->rebuildCache()[/B] in [B]XenForo/Install/Controller/Install.php[/B] at line [B]240[/B]
[*][B]XenForo_Install_Controller_Install->actionStep2b()[/B] in [B]XenForo/FrontController.php[/B] at line [B]310[/B]
[*][B]XenForo_FrontController->dispatch()[/B] in [B]XenForo/FrontController.php[/B] at line [B]132[/B]
[*][B]XenForo_FrontController->run()[/B] in [B]/home/account/public_html/jsm/install/index.php[/B] at line [B]18[/B]
[/LIST]
 
Sort by date Sort by votes
I tried everything in that and things still aren't working.

Xenforo says my server is good, I've reinstalled php, my libraries are up to date (at least support says they are, anyone know how to check this myself...I have root access, I just don't know how to check this). I've tried everything I could find in all the threads I could find, and I'm still getting this error.

I'm ready to pull my hair out, I have no clue what else to do.
 
Upvote 0 Downvote
Based on my experience with this error it is definitely a server issue. The MySQL client libraries in PHP are suspect. Upgrading those libraries has fixed the problem for other people. As I said in this post:

http://xenforo.com/community/threads/migration-issue.35809/#post-407640

...there isn't a specific bug that I have identified with MySQL. Rather it's process of elimination. I have confirmed the data is correct in XenForo up to the point when the query is handed to MySQL. Mike also confirmed this.
 
Upvote 0 Downvote
Yeah, that's just the thing, I've done all of that, and everything looks like it's up to date, which is what I don't understand.

Though, I don't actually know the process for updating the libraries (hard to find information on that apparently...or i'm just looking in the wrong places), it says they are 5.0.95
 
Upvote 0 Downvote
Staxed said:
Yeah, that's just the thing, I've done all of that, and everything looks like it's up to date, which is what I don't understand.

Though, I don't actually know the process for updating the libraries (hard to find information on that apparently...or i'm just looking in the wrong places), it says they are 5.0.95
Click to expand...
Back up the database
Back up the database again
Back up the database once more ...... You'll be updating MySQL and possibly removing it to re-install ..... You want to be sure you have a back up.

You're also maybe going to make peace with php 5.4.x I help someone try to get past this on php 5.3 and it never worked. 5.4 was the solution.

If what you say is true... Something hasn't updated....

If Debian or Ubuntu (and not using a control panel)

PHP: 
aptitude update
PHP: 
aptitude full-upgrade

If you noticed any updates applied .... Reboot.

Repeat the above process until there are no more updates. If this doesn't fix it.... Time for more work

PHP: 
 nano /etc/apt/sources.list

Makes sure this is there (add as needed)

PHP: 
# Debain Main Update
deb http://ftp.de.debian.org/debian stable main contrib non-free
deb-src http://ftp.de.debian.org/debian stable main contrib non-free
 
deb http://ftp.debian.org/debian/ squeeze-updates main contrib non-free
deb-src http://ftp.debian.org/debian/ squeeze-updates main contrib non-free
 
deb http://security.debian.org/ squeeze/updates main contrib non-free
deb-src http://security.debian.org/ squeeze/updates main contrib non-free
 
#Debian Backport
deb http://backports.debian.org/debian-backports squeeze-backports main
 
#Dotdeb.org
deb http://packages.dotdeb.org squeeze all
deb-src http://packages.dotdeb.org squeeze all
 
#Dotdeb.org php 5.4
deb http://packages.dotdeb.org squeeze-php54 all
deb-src http://packages.dotdeb.org squeeze-php54 all

SAVE, EXIT

PHP: 
  wget http://www.dotdeb.org/dotdeb.gpg
cat dotdeb.gpg | sudo apt-key add -

PHP: 
aptitude update

PHP: 
aptitude full-upgrade

This should update everything

PHP: 
 /etc/init.d/apache2 restart

You may need to reboot.

If this doesn't work..... Something is wrong with your configuration.

Back up your configuration files for PHP and MySQL. Place them aside. You're not going to use them for now.

This is where thinks get ugly... Sorry.

PHP: 
aptitude purge mysql-server mysql-client php5 php5-fpm libapache2-mod-php5-mysql php5-curl php5-gd php5-intl php-pear php5-imagick php5-imap php5-mcrypt php5-ming php5-ps php5-pspell php5-recode php5-snmp php5-sqlite php5-tidy php5-xmlrpc php5-xsl

PHP: 
 /etc/init.d/apache2 restart

PHP: 
aptitude install mysql-server mysql-client php5 php5-fpm libapache2-mod-php5-mysql php5-curl php5-gd php5-intl php-pear php5-imagick php5-imap php5-mcrypt php5-ming php5-ps php5-pspell php5-recode php5-snmp php5-sqlite php5-tidy php5-xmlrpc php5-xsl

PHP: 
 /etc/init.d/apache2 restart

You may need to reboot

You should now have a fresh install of MySQL and Php (both newest versions).

Restore your database. It may have been wiped out during the purge (most likely). This is why you were told to back it up (several times). If you didn't.... Not my fault.

All should be working now :)
 
Upvote 0 Downvote
thanks for that, i'll have to look into it. Sadly this site isn't the only thing on this server (only 3 other sites right now though), so I guess backing up everything and giving this a shot won't hurt much.

Really appreciate the steps! :D
 
Upvote 0 Downvote
Staxed said:
thanks for that, i'll have to look into it. Sadly this site isn't the only thing on this server (only 3 other sites right now though), so I guess backing up everything and giving this a shot won't hurt much.

Really appreciate the steps! :D
Click to expand...
WAIT.

If the other 3 sites are not yours and you're hosting someone else.... Make sure to back up everything. Including their databases as well.

Just good advice (and also responsible thing to do)
 
Upvote 0 Downvote
Adam Howard said:
WAIT.

If the other 3 sites are not yours and you're hosting someone else.... Make sure to back up everything. Including their databases as well.

Just good advice (and also responsible thing to do)
Click to expand...

I said I was going to back it all up in the previous post :D, they are all my sites though, so no worries there. Thanks for the concern though! :D
 
Upvote 0 Downvote
well hopefully you are still around these days.

I took a long break from doing things and am actually just not getting around to doing this. And now I realize that you gave instructions for Debian/Ubuntu...my server runs on CentOS. Do you (Adam/Anyone) happen to know the equivalent process for CentOS?
 
Upvote 0 Downvote
You must log in or register to reply here.

Similar threads

Resurgence
  • Question Question
XF 2.2 Issues with Installation
Replies
3
Views
592
Resurgence
Resurgence
Peugeot405srd
  • Question Question
XF 2.0 Issue with installing addons
Replies
4
Views
588
Peugeot405srd
Peugeot405srd
Perrie McGuire
  • Locked
  • Question Question
XF 1.5 Issue with Installation
Replies
1
Views
452
Mike
Mike
Freespirit
  • Question Question
XF 1.5 Having Issue With TDL
Replies
4
Views
3K
Freespirit
Freespirit
D
  • Question Question
XF 1.5 Troubles with installation - 404 Not Found
Replies
2
Views
1K
Denys
D
Back
Top Bottom