approving new links

[petefromaus]

Where do you make the change so new links need to be approved before appearing in the directory?
:-)

[FSGDAG]

You set it in the Categories. I'm not sure how you would go about doing it after you've already have 1000+ categories. I would imagine a 'Find and Replace' in the Admin section might help.

[petefromaus]

Thanks for that I guess I'll do it manually unless a helpful programmer reads this and comes to the rescue.
Maybe an easy way might get written into the program in the future.
cheers
pete

[FSGDAG]

Pete...

Dody might be able to confirm this, but you should be able to do the following:

In the Admin Panel, goto Database -> Find and Replace

Select Table = idx_category
Select Field = permission
From What = 0 ( zero ) <-- Do not add the brackets. I put that there so you didn't use a char instead of the numerical
Replace What = 1

Once its complete, you should go to Admin Panel -> Category -> Update Category Path

A couple of notes:

1 - You need to have 1.4 installed. There was a bug in 1.3 and previous versions that Find and Replace didn't work

2 - Before doing this MAKE A BACKUP of your entire site, especially the database. This way if it gets screwed up, your not starting from scratch!

[petefromaus]

Sorry , hadn't looked: re find and replace.
I upgraded to 1.4 and backed up etc . Everything was going great :-)
Then got to the Admin panel and don't have the option to select permission in the drop down menu.
Screen shot attached so you can see.
Any further help would be great. Cheers
pete

[petefromaus]

It had the following error message after I had another look.
Thanks
Pete

[FSGDAG]

Pete...

After you uploaded the new files, did you run the install again? The procedure for upgrading is

- Upload all files ( overwriting the existing files, except for /application.php and /key.php )
- Open in your web browser http://www.<your_site>.<tld>/install/install.php
- Choose UPGRADE from the previous version you were using

Once that is done, make sure you delete the /install directory so that your site cant be compromised.

Looking at your screen shot in the 'Find and Replace' your missing text that is in mine. So my thought is that you haven't run the upgrade yet.

[petefromaus]

The upgrade seemed to go well/ by the book. I am missing a PHP module but asked about this a while ago and found it is only the do with language translation.
That error is strange as I went to the file mentioned and it only has 100 odd lines but looks complete.
What text is missing?
Pete

[FSGDAG]

Attached is the screen shot of what it should look like.

May I suggest that you upgrade from IE8 or install FF 3.5 or Chrome. I doubt thats your total issue, but atleast you would be taking one problem out of the equation

[petefromaus]

I've installed FF and get the attached shot still.
I have to go and will have to take it up again later.
Thanks for the help.
pete

Capture3.jpg

[petefromaus]

Hi back again. Still no luck with that problem. Any more help would be great.
pete :-)

[petefromaus]

Dear FSGDAG
Had a thought, I am using the plurkified theme which was not upgraded. Is it the file contained in that theme that needs changing??

[dody]

The category permission:

0 : No need editor's approval
1 : Require editor's approval
2 : Not allowed (Invisible in add/modify a listing)
3 : Not allowed (Visible in add/modify a listing)

In order to update all category, run the following query in phpmyadmin or indexu query box:

UPDATE idx_category SET permission = '1'

[petefromaus]

Thanks Dodo,
That worked perfectly!!!
Cheers
Pete :-)