Icy Phoenix

and fauiler is when i as a admin delet a topic then i get this

SQL ERROR [ mysql4 ]

BIGINT UNSIGNED value is out of range in '(`dbname`.`ip_1231users`.`user_posts` - 1)' [1690]

SQL

UPDATE ip_1231users SET user_posts = user_posts - 1 WHERE user_id = 2

BACKTRACE

FILE: includes/db/mysql.php
LINE: 295
CALL: sql_db->sql_error()

FILE: includes/class_mcp.php
LINE: 62
CALL: sql_db->sql_query()

FILE: modcp.php
LINE: 279
CALL: class_mcp_topic->topic_delete()


can some one pls help me whit this ?

Seems like you messed up your messages counter. Can you try to go into the ACP, set your message counter to 100 (for example), and retry?

@MG: I reported this issue a few years ago. We need an "if" before decrementing the post count, because if you delete a post from a user with post_count=0, this happens.

no i am sry i start all over again and now i cant get eany thing to work when i install it its ok but when i should go to page and login its only a blank page pls help ai have a one.con server

Are you uploading Icy Phoenix in "Binary" or ASCII format?

Hello All, I have been helping Keiko with this issue and we now have his forum upgraded and more or less working.
The less is in the main "home" link, anything under the forum and the ACP seems to be working but if you hit the "Home" link we the following error:

Fatal error: Call to undefined method stdClass::parse() in /customers/6/b/2/newinternational.org.uk/httpd.www/international/includes/class_cms.php on line 402

During the update we did not get any errors and and the DB conversion, image DB update and post/signature updating all worked too.

Any suggestions?

During the upgrade, it says to delete all old Icy files, are they not overwritten when uploading the new version? Or how big a mistake would it cause?

boooooooooh wrote: [View Post]

During the upgrade, it says to delete all old Icy files, are they not overwritten when uploading the new version? Or how big a mistake would it cause?

It will overwrite files with same name, but that way leaves old deprecated files and probably some deprecated dir's still mixed in with the new?

Mixed in, and while messy, I would not expect failure unless files/folders are "detected" but we will try go over that again.

We had a small bit of progress, however links all seem to now refer to static HTML pages.
When you would expect /viewtopic.php and the forum/topic number it shows a static page instead (but it fails to load).

boooooooooh wrote: [View Post]

Mixed in, and while messy, I would not expect failure unless files/folders are "detected" but we will try go over that again.

We had a small bit of progress, however links all seem to now refer to static HTML pages.
When you would expect /viewtopic.php and the forum/topic number it shows a static page instead (but it fails to load).

That's URL rewriting, it's just to beautify URLs. If it doesn't work on your server, you can disable it in the ACP (settings => SEO).

Hi keiko

I don´t now if you get my PM
Here are the file if it was the theme you whant

Informpro wrote: [View Post]

That's URL rewriting, it's just to beautify URLs. If it doesn't work on your server, you can disable it in the ACP (settings => SEO).

That sounds promising! And would make sense, I am not sure if it was in use before and dont recall it being set after the upgrade, but we will check this and report back, thanks!

The SEO setting seems to have done the trick! Thanks! How it got enabled, not sure but perhaps while poking to fix other things.

Now, we cant just stop here I am afraid It seems there is an issue when using the black pearl theme (or any 'pearl' theme for that matter). Before I dig into the issue, I wanted to see if this is a known problem.

The block titles seem to not fill out in fluid width, I have attached an image taken with the board disabled, but the issue seen is on all block titles.

As I understand it - You are running on the version of Icy Phoenix from GitHub?

Where did you download the Black Pearl from and what version is it....... ?

Because it's unlikely to work if you are mixing old versions with new as some of those themes have not been updated for a long time.

At present its the git version and the blackpearl version is Black Pearl (for Icy Phoenix 2.0.0.86) downloaded from this site.

I couldn't find black pearl on your site (After I had to dig out the url)

So what's the theme number of Black Pearl?

Also - When you add or alter themes like your current default and something is not working - Then you need to check it for errors that you create like this.

Your <div is missing a </div - And that sort of thing "echoes" through the theme and generally screws other things up.

Thanks Mort, the missing div, this was a quickfix for the temporary theme while we tried to work out the black pearl issue. I will fix it now

For testing, I setup a test site with no previous db, just a clean install of icy from github and the black pearl theme. I have attached an image below, as you can see all is default

Black Pearl

In the black Pearl css replace what's there with this little bit.

Thanks mort, that did the trick!
And thanks for all the other input, we now have this solved and with a perfect end result!

Nothing is perfect

And those templates are written in "yesterday's" css - So these type of things are going to pop up from time to time.

A couple of things.

Snapshots from localhost are useless because it means that those who want to or are capable of helping are forced to drop everything and install what you are are using and having problems with, and it doesn't go down too well if it keeps happening.

1. We can usually resolve these problems on-line by accessing the html, css and js for that matter and it's usually the ONLY way to do it because it resolves problems that others create by modifying the themes themselves. So a "Live" test site would be handy and the theme ID as well in case it's not set as default.

2. Do you know how ridiculous that theme (or any theme for that matter) looks like on large screens 21.5 and upwards when set to full-fluid width?

So if you are inclined do something else and want it centred, no left bloody margin that is persistent when the screen is resized, and not to exceed a certain size. Just yell out if you get stuck.

Totally understand regarding the localhost. The first aim was to ensure that the site was working as before the upgrade and without any loss of data. I setup my tests as first time I have seen or worked with Icy was 3 days ago and I did not want to destroy anything.

We will be re-doing the themes now that it is working as it was before the upgrade, so its very likely you will see more from me, I will make sure its public accessable then though. And no, I am on a 21", just half an inch short

I noticed another problem with that piece of css. The forum type headers are two different heights.

This should fix it.

Informpro wrote: [View Post]

@MG: I reported this issue a few years ago. We need an "if" before decrementing the post count, because if you delete a post from a user with post_count=0, this happens.

Are you sure about that?

I'll check this.