can not create dir in file center

[1996 328ti]

When I try to create a directory, I get this message, error while writing new dir info
When I upload a file I get this message, error while insert file information

It worked before upgrading from 1.3.3 to 1.3.9

I changed permissions from 755 to 777 to the following directories
upload
filearchive
filearchive/can_be_deleted
template
content
content/ads
content/images
content/gt
content/form
content/rss
content/tmp
content/pages

phpwcms v 1.3.9

[DF6IH]

Hi Steven,

do not check for file permissions but in stead for Database. Probably rerun the DB Upgrade couple of steps b4 the beginning up to the last 1.3.9 This should solve the Problem.

Greetz


Jürgen

[1996 328ti]

I tried it on my test install and live.
Still can not create directories.

I did need to install upgrades
Upgrade release 1.3.4 to 1.3.5
Upgrade release 1.3.5 to 1.3.5.1
Upgrade release 1.3.5 to 1.5

[Jensensen]

...I did need to install upgrades
Upgrade release 1.3.4 to 1.3.5
Upgrade release 1.3.5 to 1.3.5.1
Upgrade release 1.3.5 to 1.5

So, right now, it is working well?

You must know, that we are working on public servers, live, by using THE ACTUAL devware version 1.3.9 R_SOMETHING which [already] has some DB update scripts that are called "Upgrade release 1.3.5 to 1.5".

However you must know, that you have to run that "Upgrade to 1.5" EVEN when using/doing upgrades to v.1.3.9.
It's that easy! Nobody knows, but we all should!!!¿¿¿ This is the way the headquarter manages updates! [devware]

At the end we're waiting for version 2.0 since 1.5 years.

Let's see, next week there is an "Upgrade script to 2.1" with v1.3.9 r_274

Any questions?

[1996 328ti]

So, right now, it is working well?

It works except that I can't upload files through the file center.
error while insert file information

And when I try to create a directory I still get this,
error while writing new dir info

So no, it is not working well.

Looking at my 1.3.3 version that is still live, I see
my username below
private files public files search trash can open file help
user: webmaster (admin)

In my 1.3.9 version, nothing. Is that correct?

[Jensensen]

...error while insert file information...

Who's telling? The server, the cms? What exactly is the error message?

...my username below
[ ]
Is that correct?

No!

Are you sure that you've run all of the upgrade scripts sequentially without getting any errors?

[1996 328ti]

...error while insert file information...

Who's telling? The server, the cms? What exactly is the error message?

...my username below
[ ]
Is that correct?

No!

Are you sure that you've run all of the upgrade scripts sequentially without getting any errors?

The CMS is giving me those error messages.
I ran the upgrades and they looked fine. No errors.
So I think the problem is that my username is not showing up.

[DF6IH]

Sorry for asking (perhaps) such a stupid question: But where did you do the step in DB starting at 1.3.3 -> to ?

[1996 328ti]

Sorry for asking (perhaps) such a stupid question: But where did you do the step in DB starting at 1.3.3 -> to ?

MY original install was 1.3.3

I began my upgrades with 1.3.3_to_1.3.5.sql

#####################################################
#
# PHPWCMS SQL Update
#
# Upgrade release 1.3.3 to 1.3.4
#
#####################################################
ALTER TABLE `phpwcms_article` ADD `article_priorize` INT( 5 ) NOT NULL DEFAULT '0';

MySQL said: Documentation
#1060 - Duplicate column name 'article_priorize'

Upgrade release 1.3.4 to 1.3.5
Your SQL query has been executed successfully
Upgrade release 1.3.5 to 1.3.5.1
Your SQL query has been executed successfully
Upgrade release 1.3.5 to 1.5
#1060 - Duplicate column name 'acat_archive'

[flip-flop]

You have scroll down the output list during db updating?

[1996 328ti]

You have scroll down the output list during db updating?

I did. I started with one, then the next.

Recently I used phpMyAdmin to reload the upgrades.
I may start all over on another test.

[flip-flop]

I am talking about the output window.

Please have a look into your db by phpMyAdmin.
Often there a double table index is generated by the update process.
Kill all these double indexes.

[1996 328ti]

I am talking about the output window.

Please have a look into your db by phpMyAdmin.
Often there a double table index is generated by the update process.
Kill all these double indexes.

This is what I show. Do I look in each table to look for duplicate entries?

phpwcms_address
phpwcms_ads_campaign
phpwcms_ads_formats
phpwcms_ads_place
phpwcms_ads_tracking
phpwcms_article
phpwcms_articlecat
phpwcms_articlecontent
phpwcms_bad_behavior
phpwcms_bid
phpwcms_blog
phpwcms_cache
phpwcms_calendar
phpwcms_categories
phpwcms_chat
phpwcms_content
phpwcms_country
phpwcms_crossreference
phpwcms_file
phpwcms_filecat
phpwcms_filekey
phpwcms_fonts
phpwcms_fonts_colors
phpwcms_fonts_styles
phpwcms_formresult
phpwcms_formtracking
phpwcms_forum
phpwcms_guestbook
phpwcms_imgcache
phpwcms_keyword
phpwcms_language
phpwcms_log
phpwcms_map
phpwcms_message
phpwcms_module
phpwcms_newsletter
phpwcms_newsletterqueue
phpwcms_pagelayout
phpwcms_profession
phpwcms_subscription
phpwcms_sysvalue
phpwcms_template
phpwcms_user
phpwcms_userdetail
phpwcms_usergroup
phpwcms_userlog

[flip-flop]

My Database V1.3.9 r273
tables:

Code: Select all

phpwcms_address
phpwcms_ads_campaign
phpwcms_ads_formats
phpwcms_ads_place
phpwcms_ads_tracking
phpwcms_article
phpwcms_articlecat
phpwcms_articlecontent
phpwcms_bad_behavior
phpwcms_bid
phpwcms_cache
phpwcms_calendar
phpwcms_categories
phpwcms_chat
phpwcms_content
phpwcms_country
phpwcms_crossreference
phpwcms_file
phpwcms_filecat
phpwcms_filekey
phpwcms_fonts
phpwcms_fonts_colors
phpwcms_fonts_styles
phpwcms_formresult
phpwcms_formtracking
phpwcms_glossary
phpwcms_guestbook
phpwcms_imgcache
phpwcms_keyword
phpwcms_language
phpwcms_log
phpwcms_map
phpwcms_message
phpwcms_newsletter
phpwcms_newsletterqueue
phpwcms_pagelayout
phpwcms_profession
phpwcms_shop_orders
phpwcms_shop_products
phpwcms_subscription
phpwcms_sysvalue
phpwcms_template
phpwcms_user
phpwcms_userdetail
phpwcms_usergroup
phpwcms_userlog

E.G. Index of the table phpwcms_file:

Code: Select all

Indexes:
-------------------------------------------------------------------
Keyname      Type      Cardinality     Action          Field
-------------------------------------------------------------------
PRIMARY      PRIMARY   0               [Edit] [Drop]   f_id
f_granted    INDEX     None            [Edit] [Drop]   f_granted
f_name       INDEX     None            [Edit] [Drop]   f_name
f_shortinfo  INDEX     None            [Edit] [Drop]   f_shortinfo
-------------------------------------------------------------------

In some cases e.g. f_granted exists two times. (That isn´t right)

Please have a look into any table for double indexes.

[1996 328ti]

In some cases e.g. f_granted exists two times. (That isn´t right)

Please have a look into any table for double indexes.

When I browse the file table this is the result.

MySQL returned an empty result set (i.e. zero rows). (Query took 0.0003 sec)