Sh$tload of SQL errors on fresh install

[Fatsie]

I keep getting these MySQL errors on a fresh install of classifieds, the text is too long to post on the forum so I upped it in a txt...

http://www.dierenparadijs.be/PP.txt

I want to be using an IPBv2 integration but have even tried to use no integration at all, internal user system...still the same errors.

phpMyAdmin reports 20 tables in the DB, but the numbers of records in zipData is different everytime....so I think something is fishy here...

Any help would be appreciated !

[Chuck S]

Well the load of errors is because the tables exist now what issues you have if you finish the install

You need to finish all the way through and install and then we can see where we are here

[Fatsie]

It's not only tables, the installer also tries to write duplicate records, between every install attempt I deleted the tables with phpMyAdmin so I could start over with a totally empty DB.

So it is the installer that executes certain query's twice.... ?

[Chuck S]

There is nothing in the install that is duplicated

You need to run through a full install dont worry about those duplicate errors as your tables exist answer all questions correctly and lets see where we are.

[Fatsie]

Well the reason why I started experimenting is one that has been posted a few times in other topics, "For Sale" ads can be added no problem, but "Wanted" cannot, you press "Submit" and back to step 1 you go.

My first attempt I did what you advise here, just ignore the errors...they are just duplicates...no biggy. But then I encounter the strangeness above.

I tried it with IPBv2 integration and stand alone user-system...same problem.

To make things clear, I am using a fresh install, no ads, default category "A Catergory", etc...

Right after completing the installer I place a "For Sale" add in "A Category" without problems...no sweat. Then I go into the admin panel and change "Template type" for "A Category" to "Wanted", nothing else...go back to "User Index" and try to post a "Wanted" add in "A Category"....big no-no...

[Chuck S]

In your uploadproduct templates find this and make sure the line in bold is there if not then add it

<input type="hidden" name="userid" value="{$User['userid']}" />
<input type="hidden" name="process" value="do" />

[Fatsie]

All 4 uploadproduct<nr>.tmpl files have that line (all in the last paragraph), I did not alter these files from the download ZIP

[Fatsie]

I'm off to bed for the day, I'll check back on this in the morning.....

[Chuck S]

I do not show any issues other than what I posted above and notified the developer of to update the build

You need to set the active ads wanted as usuable and set a category to use it.

Please post a url to your site and a test login

I have no problem posting wanted ads or any other ad for that matter

[Fatsie]

If the ad-type is not set to enabled in the admin-panel you are not able to select it from the drop-down in step 1 to begin with...so that clearly shows my "Wanted" ad-type is enabled.

If you set no category to use the ad-type as a "Template Type" then you are faced with an empty drop-down box in step 2 of the posting process. So only categorys with correct "Template Type" settings show up...wich is also correct in my case.

I am staring at the admin panel, Ad-Type ID 1 "Wanted" Enabled "yes", Category "A Category" Template Type "Wanted". All seems correct to me.

REMOVED FOR SECURITY BY OMEGATRON

This is a clean test install, play arround with it as much as you like...

[Chuck S]

okay in your uploadproduct.php file what is line 77? Is it this

if ( $process != "do" ) {
printheader( $cat, $Globals['pp_lang']['uploadproduct'] );

[Fatsie]

No, it is this....

if ( !isset($theimage) ) {
printheader( $cat, $Globals['pp_lang']['uploadproduct'] );

Again I did not alter the file from the download ZIP.

[Fatsie]

I have just confirmed that the download ZIP contains an uploadproduct.php file with the lines I quoted on 77 and 78.....

[Chuck S]

okay then line 77

if ( !isset($theimage) ) {

needs to be this'

if ( $process != "do" ) {

[Fatsie]

Yep, that seems to have done the trick.

Thanks for the assistance, you might want to check the ZIP