New Custom Field Error-supreme

Hi Paolo,

Ok Thanks,

gsr

Hi Stiofan,

My site requires it.

You suspicion about my technicalities is right, as I am not good at it and I don’t know much of coding, and more so how to use DBs.

Initially, I had made different CPTs, but after getting feedback, I realised that the users need to select appropriate CPT to search. However, if the listing has been made in a different CPT, the desired results don’t show up. Moreover,with the power of Multi Location plugin, I had decided to go ahead and design my site on those lines. Apart from the user friendly limitation of search, there was no way of introducing location based Advertisements (see my previous posts on the subject). Paolo had suggested the use of Widget Logic Plugin, but the said plugin limits to selection of Category of Posts, but not the location and I remember you also stating that there is no way to target location based advertisement.

In view of the these limitations, I had decided to have a sub-site ( I found a Cloning plugin) and I need to have atleast 666+ sub sites (for each Location) for each location and have fewer CPTs,(to enable user friendly search) and I would insert Advertisement based on the location
based sub sites, and with the help of widget logic, target the category.

It is for this end target, I had to restrict to fewer CPTs and create more Price Packages to enable listing targeted information and make it user friendly.

Is there no way to increase the DB size? I am planning to move to Virtual Private Servers. Will this solve the problem? Splitting the CPTs would defeat the purpose and the work done so far would go down the drain.

As suggested by you, let me open the DBs and Save to see how much improvement is there? You stated that the Upload reserves certain amount of space. Would restricting the size of upload solve the problem?

I will try out these today and let you know the results.

Thanks and rgds,

gsr

Hi Stiofan,

I again ran into the same problem, but I overcame it.

Since the error was showing as “too many Columns”, I had split the Multi Select into four parts, Viz: Facilities Available into Part 1, Part 2, Part 3 and Part 4. It worked without any errors. Please check this link.

Also I had deleted as many as 7 uploads in Education. I originally had 12 Uploads for Course material brochure; but now I cut it down to only 5.

As I go, I will keep you posted of the developments.

gsr

HI Stiofan,
Any respite from the problem. I am stuck now and not able to add any listing. The query monitor continues to repeat after the footer when logged in. The site has become terribly slow to load.
Has it got to do with the modification of data base as mentioned by you. You may try and revert to the original form. I am not sure, but a Wild guess.

A line of confirmation would be appreciated

Gsr

Hi,
Ok, I’ll wait.

Thanks

Gsr

Hi, Stiofan,

I have taken up the matter with my hosting provider and it seems that the memory limits of PhpMyAdmin are fixed at 125 MB by default and cannot be modified at this stage, as I am on a shared Hosting Plan. The problem can be resolved by moving to VPS, and also get IP address to get SSL.

I also remember reading elsewhere in the Forum about Paolo’s remark that the directory site should be on VPS so as to take the traffic and also meet the memory issues.

Therefore, I would request you to revert the changes you made to the Data Base (your post #183908). Then I will take up a back up and migrate to VPS. (I already have a backup dt 25th April, 2016). But then most of the Custom Fields additions will not appear in that said Back up.

Pl advise me if I am going in the right direction.

Thanks and rgds,

gsr