Invalid SQL error when uploading Link to Us banner

[-Om-]

I have recently had vBa Links installed, and am trying to set up my 'Link to Us' options. Adding text links via the Edit Links to Us interface works fine, but I am unable to add banners.

When I try to upload a banner image, the image does successfully upload to the proper file on my server, but nothing appears in the Admin CP---I keep getting this 'Invalid SQL' error message:

Database error in vBulletin 3.8.2:

Invalid SQL:

### INSERT QUERY GENERATED BY fetch_query_sql() ###
INSERT INTO adv_links_banners
(`title`, `displayorder`, `alttext`, `filename`, `width`, `height`, `filesize`)
VALUES
('logosmal', '1', 'logosmall', 'bgosmalllogo.jpg', '75', '30', '1340');

MySQL Error : Unknown column 'alttext' in 'field list'
Error Number : 1054

I have tried several times, with several different images of various sizes, and tried both with and without 'alttext' entered in the appropriate field.

Can you please advise?

[Brian]

Looks like the 'alttext' field is missing from your 'adv_links_banners' table. I'm not sure how that would happen unless you were upgrading from a previous version and did not run the 'Upgrade' option from the admincp/vbalinks_install.php file. If that's the case, just run the Upgrade option. Otherwise you should be able to correct the issue by running this query via your Admin CP or phpMyAdmin.

ALTER TABLE adv_links_banners ADD alttext VARCHAR(255) NOT NULL AFTER title

[Our Sponsors]

[-Om-]

Thanks Brian.

As mentioned, this wasn't an upgrade---I just purchased the program and had vBa do the installation.

I'll give the query a try and let you know if it resolves the issue.

[-Om-]

Nothing is ever easy.

I have not run any queries before, so I don't know if the "You are not authorized to execute SQL queries" message I'm getting in Admin CP is due to a VB permissions issue or a server issue.

This being a new installation (on a new site that isn't open yet), might I request your direct assistance in getting this resolved?

[Our Sponsors]

[Brian]

If you would like to submit a new support ticket or open re-open your previous install ticket (whichever is easiest for you) then I'll be glad to login and run that query for you.

[-Om-]

Done ... thank you.