Page 1 of 2
can not create dir in file center
Posted: Sun 23. Nov 2008, 23:23
by 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
Re: can not create dir in file center
Posted: Mon 24. Nov 2008, 08:22
by juergen
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
Re: can not create dir in file center
Posted: Tue 25. Nov 2008, 00:33
by 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
Re: can not create dir in file center
Posted: Tue 25. Nov 2008, 00:53
by Jensensen
1996 328ti wrote:...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?
Re: can not create dir in file center
Posted: Tue 25. Nov 2008, 01:26
by 1996 328ti
Jensensen wrote: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?
Re: can not create dir in file center
Posted: Tue 25. Nov 2008, 02:13
by Jensensen
1996 328ti wrote:...error while insert file information...
Who's telling? The server, the cms? What exactly is the error message?
1996 328ti wrote:...my username below
[ ]
Is that correct?
No!
Are you sure that you've run all of the upgrade scripts sequentially without getting any errors?
Re: can not create dir in file center
Posted: Tue 25. Nov 2008, 02:44
by 1996 328ti
Jensensen wrote:1996 328ti wrote:...error while insert file information...
Who's telling? The server, the cms? What exactly is the error message?
1996 328ti wrote:...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.
Re: can not create dir in file center
Posted: Tue 25. Nov 2008, 06:07
by juergen
Sorry for asking (perhaps) such a stupid question: But where did you do the step in DB starting at 1.3.3 -> to ?
Re: can not create dir in file center
Posted: Tue 25. Nov 2008, 13:24
by 1996 328ti
DF6IH wrote: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'
Re: can not create dir in file center
Posted: Tue 25. Nov 2008, 15:11
by flip-flop
You have scroll down the output list during db updating?
Re: can not create dir in file center
Posted: Tue 25. Nov 2008, 17:39
by 1996 328ti
flip-flop wrote: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.
Re: can not create dir in file center
Posted: Tue 25. Nov 2008, 18:31
by 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.
Re: can not create dir in file center
Posted: Tue 25. Nov 2008, 19:38
by 1996 328ti
flip-flop wrote: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
Re: can not create dir in file center
Posted: Tue 25. Nov 2008, 20:16
by 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.
Re: can not create dir in file center
Posted: Wed 26. Nov 2008, 01:19
by 1996 328ti
flip-flop wrote:
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)
