Ad Agency Installation Error Row size too large (> 8126)

hollywebvideo

Just bought your program Ad Agency....already having issues. Getting this error when installing zip...

Row size too large (> 8126). Changing some columns to TEXT or BLOB or using ROW_FORMAT=DYNAMIC or ROW_FORMAT=COMPRESSED may help. In current row format, BLOB prefix of 768 bytes is stored inline.

No Idea how to fix this. I was told it was database issue but assuming youve seen this and know a quick fix vs. me searching.

Time is of essence....trying to get this uploaded and setup asap so we can launch new site.

Ninja

hollywebvideo
Hi
The PHP configurations of the site is very low.
Kindly increase the PHP values as below :
http://prntscr.com/qhd7hw
Use recommended values. For the Mysql error its from DB apply this suggestion
Let me know if the error back after these value updates.

You can also ask the hosting provider to fix these values.

hollywebvideo

I changed the php.ini myself. That is a common thing for components. But not the solution to the issue.

However the database situation is beyond me...and the link you provided would take hiring a guru of some sort to understand. Had I known this was going to be a component in need of major database knowledge, id chosen elsewhere. No other components I use have asked anything like this of me.
Point being, this is not something i can understand or fix.

Let me know if this is fixable...otherwise will retrieve a refund.

Ninja

hollywebvideo
Hi
Its not issue from Agency, its i the DB issue of site, also this can found in future once your site has more big DB
Kindly apply this suggestion
https://stackoverflow.com/questions/22637733/mysql-error-code-1118-row-size-too-large-8126-changing-some-columns-to-te
changing the innodb_log_file_size in the my.ini text file.

Its a more simple suggestion you can apply.

hollywebvideo

I just want to get a refund...since there is no clear answer to fixing this. How do I go about doing this.

hollywebvideo

I spoke with hosting company...there is not a solution to this. There settings are not optional in certain areas such as these. One of the largest hosting companies..so they are up to par. Said cant change settings unless on dedicated server. Said the program should be built to allow lower settings, or a way to upload in smaller sections.

Not angry...just want a refund as this is unusable and we have to find a different option. First component to give us this error.

Ninja

hollywebvideo
Hi
Its something from server actually as no other users reported it .
You can ask for refund via ticket
https://www.joomlart.com/member/helpdesk/

Further i suggest you to apply suggestions to fix as its not something that is common issue

hollywebvideo

What you suggested to change in file is not possible with this hosting company. They have set limit size and you cannot alter that. So if that is the only fix, then it cannot be done. Ill contact for refund.....not really what I want or need but no choice at this point.

Ninja

hollywebvideo
Hi
Sorry its something that could not be fixed via component you may need to consult with hosting as its something should be supported most of the hosting providers.

Regards

hollywebvideo

Already did that...not gonna happen. Just need a refund.

Ninja

hollywebvideo
Hi
About refund you can submit a ticket on the helpdesk link i shared.

Regards